eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.RLM_CUM_SV dependencies on RLM_CUM_SV

Line 1: PACKAGE BODY RLM_CUM_SV AS

1: PACKAGE BODY RLM_CUM_SV AS
2: /* $Header: RLMCUMMB.pls 120.7.12020000.2 2013/03/28 10:18:56 sunilku ship $ */
3:
4: --
5: l_DEBUG NUMBER := NVL(fnd_profile.value('RLM_DEBUG_MODE'),-1);

Line 7: /=============================== rlm_cum_sv ===============================/

3:
4: --
5: l_DEBUG NUMBER := NVL(fnd_profile.value('RLM_DEBUG_MODE'),-1);
6: --
7: /*=============================== rlm_cum_sv ===============================*/
8:
9: /*============================================================================
10:
11: PROCEDURE NAME: CalculateCumKey

Line 16: x_cum_key_record IN RLM_CUM_SV.cum_key_attrib_rec_type,

12:
13: =============================================================================*/
14:
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;

Line 17: x_cum_record IN OUT NOCOPY RLM_CUM_SV.cum_rec_type)

13: =============================================================================*/
14:
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;

Line 225: rlm_cum_sv.GetLatestCum(x_cum_key_record,

221: AND (NVL(v_rlm_setup_terms_record.cum_control_code,'NO_CUM')
222: IN ('CUM_BY_DATE_PO','CUM_BY_DATE_RECORD_YEAR','CUM_BY_DATE_ONLY'))
223: THEN
224: --
225: rlm_cum_sv.GetLatestCum(x_cum_key_record,
226: v_rlm_setup_terms_record,
227: x_cum_record);
228: --
229: IF x_cum_record.record_return_status = FALSE THEN

Line 855: x_new_ship_count IN RLM_CUM_SV.t_new_ship_count := RLM_CUM_SV.g_miss_new_ship_count,

851:
852: =============================================================================*/
853:
854: PROCEDURE CalculateSupplierCum (
855: x_new_ship_count IN RLM_CUM_SV.t_new_ship_count := RLM_CUM_SV.g_miss_new_ship_count,
856: x_cum_key_record IN RLM_CUM_SV.cum_key_attrib_rec_type,
857: x_cum_record IN OUT NOCOPY RLM_CUM_SV.cum_rec_type)
858: IS
859: --

Line 856: x_cum_key_record IN RLM_CUM_SV.cum_key_attrib_rec_type,

852: =============================================================================*/
853:
854: PROCEDURE CalculateSupplierCum (
855: x_new_ship_count IN RLM_CUM_SV.t_new_ship_count := RLM_CUM_SV.g_miss_new_ship_count,
856: x_cum_key_record IN RLM_CUM_SV.cum_key_attrib_rec_type,
857: x_cum_record IN OUT NOCOPY RLM_CUM_SV.cum_rec_type)
858: IS
859: --
860: E_UNEXPECTED EXCEPTION;

Line 857: x_cum_record IN OUT NOCOPY RLM_CUM_SV.cum_rec_type)

853:
854: PROCEDURE CalculateSupplierCum (
855: x_new_ship_count IN RLM_CUM_SV.t_new_ship_count := RLM_CUM_SV.g_miss_new_ship_count,
856: x_cum_key_record IN RLM_CUM_SV.cum_key_attrib_rec_type,
857: x_cum_record IN OUT NOCOPY RLM_CUM_SV.cum_rec_type)
858: IS
859: --
860: E_UNEXPECTED EXCEPTION;
861: v_terms_level VARCHAR2(15) DEFAULT NULL;

Line 3017: PARAMETERS: x_cum_key_record IN RLM_CUM_SV.cum_key_attrib_rec_type

3013:
3014: DESCRIPTION: This procedure returns the tpcontext using CUM Key
3015: Record
3016:
3017: PARAMETERS: x_cum_key_record IN RLM_CUM_SV.cum_key_attrib_rec_type
3018: x_customer_number OUT NOCOPY VARCHAR2
3019: x_ship_to_ece_locn_code OUT NOCOPY VARCHAR2
3020: x_bill_to_ece_locn_code OUT NOCOPY VARCHAR2
3021: x_inter_ship_to_ece_locn_code OUT NOCOPY VARCHAR2

Line 3026: x_cum_key_record IN RLM_CUM_SV.cum_key_attrib_rec_type,

3022: x_tp_group_code OUT NOCOPY VARCHAR2
3023:
3024: ============================================================================*/
3025: PROCEDURE GetTPContext(
3026: x_cum_key_record IN RLM_CUM_SV.cum_key_attrib_rec_type,
3027: x_customer_number OUT NOCOPY VARCHAR2,
3028: x_ship_to_ece_locn_code OUT NOCOPY VARCHAR2,
3029: x_bill_to_ece_locn_code OUT NOCOPY VARCHAR2,
3030: x_inter_ship_to_ece_locn_code OUT NOCOPY VARCHAR2,

Line 3426: v_old_cum_counter RLM_CUM_SV.t_new_ship_count;

3422: v_num NUMBER;
3423: v_start_num NUMBER DEFAULT 0;
3424: v_end_num NUMBER DEFAULT 0;
3425: v_cum_key_record cum_key_attrib_rec_type;
3426: v_old_cum_counter RLM_CUM_SV.t_new_ship_count;
3427: p_ship_from_org_id NUMBER DEFAULT NULL;
3428: p_ship_to_org_id NUMBER DEFAULT NULL;
3429: p_intmed_ship_to_org_id NUMBER DEFAULT NULL;
3430: p_bill_to_org_id NUMBER DEFAULT NULL;

Line 3450: v_old_cum_records RLM_CUM_SV.t_cums;

3446: v_trail4 VARCHAR2(5000);
3447: v_trail5 VARCHAR2(5000);
3448: v_trail6 VARCHAR2(5000);
3449: --v_old_cum_table t_old_cum;
3450: v_old_cum_records RLM_CUM_SV.t_cums;
3451: v_tmp_old_table t_old_cum;
3452: ----
3453: ---- Used by Process Order API
3454: --

Line 3463: v_cum_records RLM_CUM_SV.t_cums;

3459: v_msg_data VARCHAR2(2000);
3460: v_adjustment_ids t_new_ship_count;
3461: v_adjustment_date DATE DEFAULT NULL;
3462: v_header_id NUMBER;
3463: v_cum_records RLM_CUM_SV.t_cums;
3464: v_msg_count NUMBER;
3465: adj_qty NUMBER DEFAULT 0;
3466: l_file_val VARCHAR2(80);
3467: v_om_dbg_dir VARCHAR2(80);

Line 3698: rlm_cum_sv.GetCums(v_rlm_setup_terms_rec

3694: v_cum_key_record.ship_to_address_id := v_ship_to_address_id;
3695: v_cum_key_record.bill_to_address_id := v_bill_to_address_id;
3696:
3697:
3698: rlm_cum_sv.GetCums(v_rlm_setup_terms_rec
3699: ,v_terms_level
3700: ,v_cum_key_record
3701: ,x_transaction_start_date
3702: ,v_end_date_time

Line 3836: rlm_cum_sv.GetShippLines(

3832: then delete this table
3833: */
3834: v_tmp_old_table(v_index2) := p_cum_key_id;
3835: --
3836: rlm_cum_sv.GetShippLines(
3837: x_cum_key_id => p_cum_key_id,
3838: x_ship_from_org_id => p_ship_from_org_id,
3839: x_ship_to_org_id => p_ship_to_org_id,
3840: x_intmed_ship_to_org_id => p_intmed_ship_to_org_id,

Line 3877: rlm_cum_sv.GetShippLines(

3873: --new cum correctly.
3874: --
3875: v_end_date_time := SYSDATE;
3876: --
3877: rlm_cum_sv.GetShippLines(
3878: x_cum_key_id => p_cum_key_id,
3879: x_ship_from_org_id => p_ship_from_org_id,
3880: x_ship_to_org_id => p_ship_to_org_id,
3881: x_intmed_ship_to_org_id => p_intmed_ship_to_org_id,

Line 3891: rlm_cum_sv.quicksort(g_cum_oe_lines.FIRST,

3887: x_index => v_shipLineCounter);
3888: --
3889: IF g_cum_oe_lines.COUNT > 0 THEN
3890: --
3891: rlm_cum_sv.quicksort(g_cum_oe_lines.FIRST,
3892: g_cum_oe_lines.LAST,
3893: C_cum_oe_lines);
3894: --
3895: END IF;

Line 3901: rlm_cum_sv.SetSupplierCum(

3897: -- Need to set called_by_reset_cum to 'Y'
3898: v_cum_key_record.called_by_reset_cum := 'Y';
3899: --
3900:
3901: rlm_cum_sv.SetSupplierCum(
3902: x_index => v_index,
3903: x_cum_key_record => v_cum_key_record,
3904: x_transaction_start_date => x_transaction_start_date,
3905: x_cum_records => v_cum_records,

Line 4024: rlm_cum_sv.quicksort(g_oe_tmp_line_tbl.FIRST,

4020: RAISE e_NoShipment;
4021: --
4022: END IF;
4023: --
4024: rlm_cum_sv.quicksort(g_oe_tmp_line_tbl.FIRST,
4025: g_oe_tmp_line_tbl.LAST,
4026: RLM_CUM_SV.C_line_table_type);
4027: --
4028: v_index3 := g_oe_tmp_line_tbl.FIRST;

Line 4026: RLM_CUM_SV.C_line_table_type);

4022: END IF;
4023: --
4024: rlm_cum_sv.quicksort(g_oe_tmp_line_tbl.FIRST,
4025: g_oe_tmp_line_tbl.LAST,
4026: RLM_CUM_SV.C_line_table_type);
4027: --
4028: v_index3 := g_oe_tmp_line_tbl.FIRST;
4029: --
4030: IF (l_debug <> -1) THEN

Line 4751: x_cum_key_record IN OUT NOCOPY rlm_cum_sv.cum_key_attrib_rec_type,

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 ,
4754: x_ship_from_org_id IN NUMBER,
4755: x_ship_to_org_id IN NUMBER,

Line 4758: x_cum_records OUT NOCOPY RLM_CUM_SV.t_cums,

4754: x_ship_from_org_id IN NUMBER,
4755: x_ship_to_org_id IN NUMBER,
4756: x_intmed_ship_to_org_id IN NUMBER,
4757: x_bill_to_org_id IN NUMBER,
4758: x_cum_records OUT NOCOPY RLM_CUM_SV.t_cums,
4759: x_old_cum_records OUT NOCOPY RLM_CUM_SV.t_cums,
4760: x_counter OUT NOCOPY RLM_CUM_SV.t_new_ship_count,
4761: x_return_status OUT NOCOPY NUMBER)
4762: IS

Line 4759: x_old_cum_records OUT NOCOPY RLM_CUM_SV.t_cums,

4755: x_ship_to_org_id IN NUMBER,
4756: x_intmed_ship_to_org_id IN NUMBER,
4757: x_bill_to_org_id IN NUMBER,
4758: x_cum_records OUT NOCOPY RLM_CUM_SV.t_cums,
4759: x_old_cum_records OUT NOCOPY RLM_CUM_SV.t_cums,
4760: x_counter OUT NOCOPY RLM_CUM_SV.t_new_ship_count,
4761: x_return_status OUT NOCOPY NUMBER)
4762: IS
4763: v_cum_control_code rlm_cust_shipto_terms.cum_control_code%TYPE;

Line 4760: x_counter OUT NOCOPY RLM_CUM_SV.t_new_ship_count,

4756: x_intmed_ship_to_org_id IN NUMBER,
4757: x_bill_to_org_id IN NUMBER,
4758: x_cum_records OUT NOCOPY RLM_CUM_SV.t_cums,
4759: x_old_cum_records OUT NOCOPY RLM_CUM_SV.t_cums,
4760: x_counter OUT NOCOPY RLM_CUM_SV.t_new_ship_count,
4761: x_return_status OUT NOCOPY NUMBER)
4762: IS
4763: v_cum_control_code rlm_cust_shipto_terms.cum_control_code%TYPE;
4764: v_cum_org_level_code rlm_cust_shipto_terms.cum_org_level_code%TYPE;

Line 4765: v_tmp_cum_record rlm_cum_sv.cum_rec_type;

4761: x_return_status OUT NOCOPY NUMBER)
4762: IS
4763: v_cum_control_code rlm_cust_shipto_terms.cum_control_code%TYPE;
4764: v_cum_org_level_code rlm_cust_shipto_terms.cum_org_level_code%TYPE;
4765: v_tmp_cum_record rlm_cum_sv.cum_rec_type;
4766: v_address_id NUMBER;
4767: v_cum_rec_ctr NUMBER DEFAULT 0;
4768: v_old_cum_ctr NUMBER DEFAULT 0;
4769: v_counter_ctr NUMBER DEFAULT 0;

Line 5438: ** x_cum_records IN OUT NOCOPY RLM_CUM_SV.t_cums

5434: This is the index for table x_cum_records
5435: ** x_cum_key_record IN cum_key_attrib_rec_type
5436: contains information about address ids
5437: ** x_transaction_start_date IN DATE
5438: ** x_cum_records IN OUT NOCOPY RLM_CUM_SV.t_cums
5439: Using the x_index we get the new cum record which needs to be rest
5440: ** x_return_status OUT NOCOPY BOOLEAN
5441: This will return FALSE if unexpected error happens
5442: ** x_counter IN OUT NOCOPY NUMBER

Line 5451: x_cum_records IN OUT NOCOPY RLM_CUM_SV.t_cums,

5447: PROCEDURE SetSupplierCum (
5448: x_index IN NUMBER,
5449: x_cum_key_record IN cum_key_attrib_rec_type,
5450: x_transaction_start_date IN DATE,
5451: x_cum_records IN OUT NOCOPY RLM_CUM_SV.t_cums,
5452: x_return_status OUT NOCOPY BOOLEAN,
5453: x_counter IN OUT NOCOPY NUMBER,
5454: x_adjustment_date IN OUT NOCOPY DATE )
5455: IS

Line 5689: IF sortType = RLM_CUM_SV.C_line_table_type THEN

5685: low := First;
5686: high := Last;
5687:
5688: /* Select an element from the middle. */
5689: IF sortType = RLM_CUM_SV.C_line_table_type THEN
5690: pivot_n := g_oe_tmp_line_tbl(TRUNC((First + Last) / 2)).header_id;
5691: LOOP
5692: /* Find lowest element that is >= Pivot */
5693: WHILE g_oe_tmp_line_tbl(Low).header_id < Pivot_n LOOP

Line 5743: rlm_message_sv.sql_error('rlm_cum_sv.QuickSort', v_Progress);

5739: --
5740: EXCEPTION
5741:
5742: WHEN OTHERS THEN
5743: rlm_message_sv.sql_error('rlm_cum_sv.QuickSort', v_Progress);
5744: --
5745: IF (l_debug <> -1) THEN
5746: rlm_core_sv.dlog(C_DEBUG,'progress',v_Progress);
5747: rlm_core_sv.dpop(C_DEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));

Line 5765: T2 rlm_cum_sv.cum_oe_lines_type;

5761: sortType IN NUMBER)
5762: IS
5763:
5764: T oe_order_pub.Line_Rec_Type ;
5765: T2 rlm_cum_sv.cum_oe_lines_type;
5766: v_Progress VARCHAR2(3) := '010';
5767:
5768: BEGIN
5769:

Line 5772: IF sortType = rlm_cum_sv.C_line_table_type THEN

5768: BEGIN
5769:
5770: -- rlm_core_sv.dpush(C_SDEBUG,'Swap');
5771:
5772: IF sortType = rlm_cum_sv.C_line_table_type THEN
5773: T := g_oe_tmp_line_tbl(i);
5774: g_oe_tmp_line_tbl(i) := g_oe_tmp_line_tbl(j);
5775: g_oe_tmp_line_tbl(j) := T;
5776: ELSE

Line 5787: --rlm_message_sv.sql_error('rlm_cum_sv.Swap', v_Progress);

5783:
5784: EXCEPTION
5785:
5786: WHEN OTHERS THEN
5787: --rlm_message_sv.sql_error('rlm_cum_sv.Swap', v_Progress);
5788: --rlm_core_sv.dlog(C_DEBUG,'progress',v_Progress);
5789: --rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
5790: raise;
5791:

Line 5909: PROCEDURE UpdateOldKey(x_old_cum_records IN OUT NOCOPY RLM_CUM_SV.t_cums,

5905: PARAMETERS: x_old_cum_table IN t_old_cum
5906:
5907: ============================================================================*/
5908: --{
5909: PROCEDURE UpdateOldKey(x_old_cum_records IN OUT NOCOPY RLM_CUM_SV.t_cums,
5910: x_shipment_rule_code IN VARCHAR2,
5911: x_cutoff_time IN DATE,
5912: x_cum_key_record IN OUT NOCOPY cum_key_attrib_rec_type,
5913: x_ship_from_org_id IN NUMBER,

Line 5971: rlm_cum_sv.GetShippLines(

5967: IF (l_debug <> -1) THEN
5968: rlm_core_sv.dlog(C_DEBUG,'inventory_item_id', x_cum_key_record.inventory_item_id);
5969: END IF;
5970: --
5971: rlm_cum_sv.GetShippLines(
5972: x_cum_key_id => x_old_cum_records(cum_records_counter).cum_key_id,
5973: x_ship_from_org_id => x_ship_from_org_id,
5974: x_ship_to_org_id => x_ship_to_org_id,
5975: x_intmed_ship_to_org_id => x_intmed_ship_to_org_id,

Line 5985: rlm_cum_sv.quicksort(g_cum_oe_lines.FIRST,

5981: x_index => v_index);
5982: --
5983: IF g_cum_oe_lines.COUNT > 0 THEN
5984: --
5985: rlm_cum_sv.quicksort(g_cum_oe_lines.FIRST,
5986: g_cum_oe_lines.LAST,
5987: C_cum_oe_lines);
5988: --
5989: END IF;

Line 6006: rlm_cum_sv.SetSupplierCum(

6002: -- Need to set called_by_reset_cum to 'Y'
6003: x_cum_key_record.called_by_reset_cum := 'Y';
6004: --
6005:
6006: rlm_cum_sv.SetSupplierCum(
6007: x_index => cum_records_counter,
6008: x_cum_key_record => x_cum_key_record,
6009: x_transaction_start_date => NULL,
6010: x_cum_records => x_old_cum_records,

Line 6090: rlm_cum_sv.quicksort(g_oe_tmp_line_tbl.FIRST,

6086: RAISE e_NoShipment;
6087: --
6088: END IF;
6089: --
6090: rlm_cum_sv.quicksort(g_oe_tmp_line_tbl.FIRST,
6091: g_oe_tmp_line_tbl.LAST,
6092: RLM_CUM_SV.C_line_table_type);
6093: --
6094: v_tmp_line_idx := g_oe_tmp_line_tbl.FIRST;

Line 6092: RLM_CUM_SV.C_line_table_type);

6088: END IF;
6089: --
6090: rlm_cum_sv.quicksort(g_oe_tmp_line_tbl.FIRST,
6091: g_oe_tmp_line_tbl.LAST,
6092: RLM_CUM_SV.C_line_table_type);
6093: --
6094: v_tmp_line_idx := g_oe_tmp_line_tbl.FIRST;
6095: --
6096: IF (l_debug <> -1) THEN

Line 6523: x_cum_key_record IN RLM_CUM_SV.cum_key_attrib_rec_type,

6519:
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

Line 6525: x_cum_record IN OUT NOCOPY RLM_CUM_SV.cum_rec_type,

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;
6529: p_ship_from_org_id NUMBER DEFAULT NULL;

Line 6571: OR x_called_from_vd = rlm_cum_sv.k_CalledByVD

6567: AND NVL(customer_item_id,0) = NVL(p_customer_item_id,0)
6568: AND cum_start_date IS NOT NULL
6569: --AND (cum_start_date < SYSDATE --Bugfix 10053830
6570: AND (cum_start_date < nvl(rlm_dp_sv.g_dsp_start_time,sysdate) --Bugfix 10053830
6571: OR x_called_from_vd = rlm_cum_sv.k_CalledByVD
6572: )
6573: AND purchase_order_number IS NULL
6574: AND cust_record_year IS NULL
6575: AND NVL(inactive_flag,'N') = 'N'

Line 6603: OR x_called_from_vd = rlm_cum_sv.k_CalledByVD

6599: AND NVL(customer_item_id,0)= NVL(p_customer_item_id,0)
6600: AND cum_start_date IS NOT NULL
6601: --AND (cum_start_date < SYSDATE --Bugfix 10053830
6602: AND (cum_start_date < nvl(rlm_dp_sv.g_dsp_start_time,sysdate) --Bugfix 10053830
6603: OR x_called_from_vd = rlm_cum_sv.k_CalledByVD
6604: )
6605: AND purchase_order_number IS NULL
6606: AND cust_record_year IS NULL
6607: AND NVL(inactive_flag,'N') = 'N'

Line 6635: OR x_called_from_vd = rlm_cum_sv.k_CalledByVD

6631: AND NVL(customer_item_id,0)= NVL(p_customer_item_id,0)
6632: AND cum_start_date IS NOT NULL
6633: --AND (cum_start_date < SYSDATE --Bugfix 10053830
6634: AND (cum_start_date < nvl(rlm_dp_sv.g_dsp_start_time,sysdate) --Bugfix 10053830
6635: OR x_called_from_vd = rlm_cum_sv.k_CalledByVD
6636: )
6637: AND purchase_order_number IS NULL
6638: AND cust_record_year IS NOT NULL
6639: AND (cust_record_year = p_cust_record_year

Line 6670: OR x_called_from_vd = rlm_cum_sv.k_CalledByVD

6666: AND NVL(customer_item_id,0) = NVL(p_customer_item_id,0)
6667: AND cum_start_date IS NOT NULL
6668: --AND (cum_start_date < SYSDATE --Bugfix 10053830
6669: AND (cum_start_date < nvl(rlm_dp_sv.g_dsp_start_time,sysdate) --Bugfix 10053830
6670: OR x_called_from_vd = rlm_cum_sv.k_CalledByVD
6671: )
6672: AND purchase_order_number IS NULL
6673: AND cust_record_year IS NOT NULL
6674: AND (cust_record_year = p_cust_record_year

Line 6705: OR x_called_from_vd = rlm_cum_sv.k_CalledByVD

6701: AND NVL(customer_item_id,0) = NVL(p_customer_item_id,0)
6702: AND cum_start_date IS NOT NULL
6703: --AND (cum_start_date < SYSDATE --Bugfix 10053830
6704: AND (cum_start_date < nvl(rlm_dp_sv.g_dsp_start_time,sysdate) --Bugfix 10053830
6705: OR x_called_from_vd = rlm_cum_sv.k_CalledByVD
6706: )
6707: AND purchase_order_number IS NOT NULL
6708: AND (purchase_order_number = p_purchase_order_number
6709: OR p_purchase_order_number IS NULL

Line 6740: OR x_called_from_vd = rlm_cum_sv.k_CalledByVD

6736: AND NVL(customer_item_id,0)= NVL(p_customer_item_id,0)
6737: AND cum_start_date IS NOT NULL
6738: --AND (cum_start_date < SYSDATE --Bugfix 10053830
6739: AND (cum_start_date < nvl(rlm_dp_sv.g_dsp_start_time,sysdate) --Bugfix 10053830
6740: OR x_called_from_vd = rlm_cum_sv.k_CalledByVD
6741: )
6742:
6743: AND purchase_order_number IS NOT NULL
6744: AND (purchase_order_number = p_purchase_order_number

Line 7052: IF (x_called_from_vd = rlm_cum_sv.k_CalledByVD )

7048: IF x_cum_record.cum_key_id IS NOT NULL THEN
7049: --
7050: x_cum_record.record_return_status := TRUE;
7051: --
7052: IF (x_called_from_vd = rlm_cum_sv.k_CalledByVD )
7053: AND NVL(x_cum_record.cum_start_date,SYSDATE) > SYSDATE
7054: THEN
7055: --
7056: x_cum_record.msg_name := 'RLM_CUM_START_FUTURE';

Line 7188: rlm_message_sv.sql_error('Locking Cum Key Failed', 'rlm_cum_sv.LockCumKey');

7184: RETURN(FALSE);
7185: --
7186: WHEN OTHERS THEN
7187: --
7188: rlm_message_sv.sql_error('Locking Cum Key Failed', 'rlm_cum_sv.LockCumKey');
7189: --
7190: IF (l_debug <> -1) THEN
7191: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: OTHER - sql error');
7192: END IF;

Line 7199: END RLM_CUM_SV;

7195: --
7196: END LockCumKey;
7197:
7198:
7199: END RLM_CUM_SV;