DBA Data[Home] [Help]

APPS.RLM_CUM_SV dependencies on RLM_SETUP_TERMS_SV

Line 19: v_rlm_setup_terms_record rlm_setup_terms_sv.setup_terms_rec_typ;

15: PROCEDURE CalculateCumKey (
16: x_cum_key_record IN RLM_CUM_SV.cum_key_attrib_rec_type,
17: x_cum_record IN OUT NOCOPY RLM_CUM_SV.cum_rec_type)
18: IS
19: v_rlm_setup_terms_record rlm_setup_terms_sv.setup_terms_rec_typ;
20: v_cum_control_code rlm_cust_shipto_terms.cum_control_code%TYPE;
21: v_cum_org_level_code rlm_cust_shipto_terms.cum_org_level_code%TYPE;
22: v_address_id NUMBER;
23: v_terms_level VARCHAR2(20) DEFAULT NULL;

Line 861: rlm_setup_record rlm_setup_terms_sv.setup_terms_rec_typ;

857: v_terms_level VARCHAR2(15) DEFAULT NULL;
858: v_terms_level2 VARCHAR2(15) DEFAULT NULL;
859: v_setup_terms_msg VARCHAR2(2000);
860: v_return_status BOOLEAN DEFAULT FALSE;
861: rlm_setup_record rlm_setup_terms_sv.setup_terms_rec_typ;
862: v_cutoff_date DATE;
863: v_ship_to_org_id NUMBER;
864: v_bill_to_org_id NUMBER;
865: adj_qty NUMBER DEFAULT 0;

Line 1420: v_rlm_setup_terms_record rlm_setup_terms_sv.setup_terms_rec_typ;

1416: IS
1417: --
1418: --Local Variables
1419: --
1420: v_rlm_setup_terms_record rlm_setup_terms_sv.setup_terms_rec_typ;
1421: v_cum_key_record cum_key_attrib_rec_type;
1422: v_cum_record cum_rec_type;
1423: v_delivery_id NUMBER;
1424: v_header_id NUMBER;

Line 2690: v_rlm_setup_terms_record rlm_setup_terms_sv.setup_terms_rec_typ;

2686: v_temp VARCHAR2(10);
2687: v_terms_level VARCHAR2(25);
2688: v_setup_terms_msg VARCHAR2(2000);
2689: v_return_status BOOLEAN;
2690: v_rlm_setup_terms_record rlm_setup_terms_sv.setup_terms_rec_typ;
2691:
2692: BEGIN
2693:
2694: v_terms_level := 'CUSTOMER_ITEM';

Line 2735: v_rlm_setup_terms_record rlm_setup_terms_sv.setup_terms_rec_typ;

2731: v_temp VARCHAR2(10);
2732: v_terms_level VARCHAR2(25);
2733: v_setup_terms_msg VARCHAR2(2000);
2734: v_return_status BOOLEAN;
2735: v_rlm_setup_terms_record rlm_setup_terms_sv.setup_terms_rec_typ;
2736:
2737: BEGIN
2738:
2739: -- v_terms_level := 'CUSTOMER';

Line 2784: v_rlm_setup_terms_record rlm_setup_terms_sv.setup_terms_rec_typ;

2780: v_temp VARCHAR2(10);
2781: v_terms_level VARCHAR2(25);
2782: v_setup_terms_msg VARCHAR2(2000);
2783: v_return_status BOOLEAN;
2784: v_rlm_setup_terms_record rlm_setup_terms_sv.setup_terms_rec_typ;
2785: v_customer_id NUMBER;
2786:
2787: BEGIN
2788: --

Line 2866: v_rlm_setup_terms_record rlm_setup_terms_sv.setup_terms_rec_typ;

2862: v_ship_to_address_id NUMBER;
2863: v_customer_item_id NUMBER;
2864: v_customer_id NUMBER;
2865: v_terms_level VARCHAR2(20) DEFAULT NULL;
2866: v_rlm_setup_terms_record rlm_setup_terms_sv.setup_terms_rec_typ;
2867: v_setup_terms_msg VARCHAR2(2000);
2868: v_setup_terms_status BOOLEAN;
2869: v_cust_po_number VARCHAR2(50); --Bugfix 7007638
2870: v_industry_attribute1 VARCHAR2(150); --Bugfix 7007638

Line 3408: v_rlm_setup_terms_rec rlm_setup_terms_sv.setup_terms_rec_typ;

3404: x_transaction_end_date IN DATE,
3405: x_return_status OUT NOCOPY BOOLEAN)
3406: IS
3407: --
3408: v_rlm_setup_terms_rec rlm_setup_terms_sv.setup_terms_rec_typ;
3409: v_index NUMBER;
3410: v_index2 NUMBER;
3411: v_index3 NUMBER;
3412: v_num NUMBER;

Line 4714: rlm_setup_terms_sv.get_setup_terms

4710: ** x_rlm_setup_terms_record IN
4711: This is setupterms generated from the resetCums parameters
4712: ** x_terms_level IN
4713: This is the same as parameter x_terms_definition_level of
4714: rlm_setup_terms_sv.get_setup_terms
4715: ** x_cum_key_record IN
4716: This records would containe the followings if it could be derived in
4717: resetcum
4718: bill_to_address_id, ship_to_address_id, intrmd_ship_to_address_id,

Line 4739: x_rlm_setup_terms_record IN rlm_setup_terms_sv.setup_terms_rec_typ,

4735:
4736: =============================================================================*/
4737:
4738: PROCEDURE GetCums (
4739: x_rlm_setup_terms_record IN rlm_setup_terms_sv.setup_terms_rec_typ,
4740: x_terms_level IN VARCHAR2,
4741: x_cum_key_record IN OUT NOCOPY rlm_cum_sv.cum_key_attrib_rec_type,
4742: x_transaction_start_date IN DATE,
4743: x_transaction_end_date IN DATE ,

Line 6514: x_rlm_setup_terms_record IN rlm_setup_terms_sv.setup_terms_rec_typ,

6510:
6511:
6512: PROCEDURE GetLatestCum (
6513: x_cum_key_record IN RLM_CUM_SV.cum_key_attrib_rec_type,
6514: x_rlm_setup_terms_record IN rlm_setup_terms_sv.setup_terms_rec_typ,
6515: x_cum_record IN OUT NOCOPY RLM_CUM_SV.cum_rec_type,
6516: x_called_from_vd IN NUMBER)
6517: IS
6518: v_cum_org_level_code rlm_cust_shipto_terms.cum_org_level_code%TYPE;