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 865: rlm_setup_record rlm_setup_terms_sv.setup_terms_rec_typ;

861: v_terms_level VARCHAR2(15) DEFAULT NULL;
862: v_terms_level2 VARCHAR2(15) DEFAULT NULL;
863: v_setup_terms_msg VARCHAR2(2000);
864: v_return_status BOOLEAN DEFAULT FALSE;
865: rlm_setup_record rlm_setup_terms_sv.setup_terms_rec_typ;
866: v_cutoff_date DATE;
867: v_ship_to_org_id NUMBER;
868: v_bill_to_org_id NUMBER;
869: adj_qty NUMBER DEFAULT 0;

Line 1429: v_rlm_setup_terms_record rlm_setup_terms_sv.setup_terms_rec_typ;

1425: IS
1426: --
1427: --Local Variables
1428: --
1429: v_rlm_setup_terms_record rlm_setup_terms_sv.setup_terms_rec_typ;
1430: v_cum_key_record cum_key_attrib_rec_type;
1431: v_cum_record cum_rec_type;
1432: v_delivery_id NUMBER;
1433: v_header_id NUMBER;

Line 2700: v_rlm_setup_terms_record rlm_setup_terms_sv.setup_terms_rec_typ;

2696: v_temp VARCHAR2(10);
2697: v_terms_level VARCHAR2(25);
2698: v_setup_terms_msg VARCHAR2(2000);
2699: v_return_status BOOLEAN;
2700: v_rlm_setup_terms_record rlm_setup_terms_sv.setup_terms_rec_typ;
2701:
2702: BEGIN
2703:
2704: v_terms_level := 'CUSTOMER_ITEM';

Line 2745: v_rlm_setup_terms_record rlm_setup_terms_sv.setup_terms_rec_typ;

2741: v_temp VARCHAR2(10);
2742: v_terms_level VARCHAR2(25);
2743: v_setup_terms_msg VARCHAR2(2000);
2744: v_return_status BOOLEAN;
2745: v_rlm_setup_terms_record rlm_setup_terms_sv.setup_terms_rec_typ;
2746:
2747: BEGIN
2748:
2749: -- v_terms_level := 'CUSTOMER';

Line 2794: v_rlm_setup_terms_record rlm_setup_terms_sv.setup_terms_rec_typ;

2790: v_temp VARCHAR2(10);
2791: v_terms_level VARCHAR2(25);
2792: v_setup_terms_msg VARCHAR2(2000);
2793: v_return_status BOOLEAN;
2794: v_rlm_setup_terms_record rlm_setup_terms_sv.setup_terms_rec_typ;
2795: v_customer_id NUMBER;
2796:
2797: BEGIN
2798: --

Line 2876: v_rlm_setup_terms_record rlm_setup_terms_sv.setup_terms_rec_typ;

2872: v_ship_to_address_id NUMBER;
2873: v_customer_item_id NUMBER;
2874: v_customer_id NUMBER;
2875: v_terms_level VARCHAR2(20) DEFAULT NULL;
2876: v_rlm_setup_terms_record rlm_setup_terms_sv.setup_terms_rec_typ;
2877: v_setup_terms_msg VARCHAR2(2000);
2878: v_setup_terms_status BOOLEAN;
2879: v_cust_po_number VARCHAR2(50); --Bugfix 7007638
2880: v_industry_attribute1 VARCHAR2(150); --Bugfix 7007638

Line 3418: v_rlm_setup_terms_rec rlm_setup_terms_sv.setup_terms_rec_typ;

3414: x_transaction_end_date IN DATE,
3415: x_return_status OUT NOCOPY BOOLEAN)
3416: IS
3417: --
3418: v_rlm_setup_terms_rec rlm_setup_terms_sv.setup_terms_rec_typ;
3419: v_index NUMBER;
3420: v_index2 NUMBER;
3421: v_index3 NUMBER;
3422: v_num NUMBER;

Line 4724: rlm_setup_terms_sv.get_setup_terms

4720: ** x_rlm_setup_terms_record IN
4721: This is setupterms generated from the resetCums parameters
4722: ** x_terms_level IN
4723: This is the same as parameter x_terms_definition_level of
4724: rlm_setup_terms_sv.get_setup_terms
4725: ** x_cum_key_record IN
4726: This records would containe the followings if it could be derived in
4727: resetcum
4728: bill_to_address_id, ship_to_address_id, intrmd_ship_to_address_id,

Line 4749: x_rlm_setup_terms_record IN rlm_setup_terms_sv.setup_terms_rec_typ,

4745:
4746: =============================================================================*/
4747:
4748: PROCEDURE GetCums (
4749: x_rlm_setup_terms_record IN rlm_setup_terms_sv.setup_terms_rec_typ,
4750: x_terms_level IN VARCHAR2,
4751: x_cum_key_record IN OUT NOCOPY rlm_cum_sv.cum_key_attrib_rec_type,
4752: x_transaction_start_date IN DATE,
4753: x_transaction_end_date IN DATE ,

Line 6524: x_rlm_setup_terms_record IN rlm_setup_terms_sv.setup_terms_rec_typ,

6520:
6521:
6522: PROCEDURE GetLatestCum (
6523: x_cum_key_record IN RLM_CUM_SV.cum_key_attrib_rec_type,
6524: x_rlm_setup_terms_record IN rlm_setup_terms_sv.setup_terms_rec_typ,
6525: x_cum_record IN OUT NOCOPY RLM_CUM_SV.cum_rec_type,
6526: x_called_from_vd IN NUMBER)
6527: IS
6528: v_cum_org_level_code rlm_cust_shipto_terms.cum_org_level_code%TYPE;