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.OKL_CSH_ORDER_SEQ_PVT dependencies on OKL_BPD_CSH_ORDER_UV

Line 34: l_cshorder_sequence OKL_BPD_CSH_ORDER_UV.SEQUENCE_NUMBER%TYPE;

30: l_msg_count NUMBER;
31: l_msg_data VARCHAR2(2000);
32: i NUMBER;
33:
34: l_cshorder_sequence OKL_BPD_CSH_ORDER_UV.SEQUENCE_NUMBER%TYPE;
35: l_cshorder_seqmax OKL_BPD_CSH_ORDER_UV.SEQUENCE_NUMBER%TYPE;
36: l_cat_id OKL_BPD_CSH_ORDER_UV.CAT_ID%TYPE;
37: l_countless INTEGER;
38: l_newrownum INTEGER;

Line 35: l_cshorder_seqmax OKL_BPD_CSH_ORDER_UV.SEQUENCE_NUMBER%TYPE;

31: l_msg_data VARCHAR2(2000);
32: i NUMBER;
33:
34: l_cshorder_sequence OKL_BPD_CSH_ORDER_UV.SEQUENCE_NUMBER%TYPE;
35: l_cshorder_seqmax OKL_BPD_CSH_ORDER_UV.SEQUENCE_NUMBER%TYPE;
36: l_cat_id OKL_BPD_CSH_ORDER_UV.CAT_ID%TYPE;
37: l_countless INTEGER;
38: l_newrownum INTEGER;
39: l_count INTEGER;

Line 36: l_cat_id OKL_BPD_CSH_ORDER_UV.CAT_ID%TYPE;

32: i NUMBER;
33:
34: l_cshorder_sequence OKL_BPD_CSH_ORDER_UV.SEQUENCE_NUMBER%TYPE;
35: l_cshorder_seqmax OKL_BPD_CSH_ORDER_UV.SEQUENCE_NUMBER%TYPE;
36: l_cat_id OKL_BPD_CSH_ORDER_UV.CAT_ID%TYPE;
37: l_countless INTEGER;
38: l_newrownum INTEGER;
39: l_count INTEGER;
40: currseq INTEGER;

Line 61: FROM OKL_BPD_CSH_ORDER_UV sta

57: -------------------
58: -- Get the order with highest sequence less than the given seq
59: CURSOR c_csh_ordr_seq (l_sequence_number IN NUMBER) IS
60: SELECT max(sta.SEQUENCE_NUMBER) MAXSEQ
61: FROM OKL_BPD_CSH_ORDER_UV sta
62: WHERE sta.SEQUENCE_NUMBER <= l_sequence_number
63: ------------------------------------------------------------------------------------
64: AND sta.ORG_ID = OKL_CONTEXT.get_okc_org_id --dkagrawa changed for MOAC -- multi org compliant
65: ------------------------------------------------------------------------------------

Line 71: FROM OKL_BPD_CSH_ORDER_UV sta

67:
68: -- Get the count of total orders
69: CURSOR c_csh_ordr_count IS
70: SELECT count(*) COUNT
71: FROM OKL_BPD_CSH_ORDER_UV sta
72: --------------------------------------------------------------------------------------
73: WHERE sta.ORG_ID = OKL_CONTEXT.get_okc_org_id; --dkagrawa changed for MOAC -- multi org compliant
74: --------------------------------------------------------------------------------------
75:

Line 80: FROM OKL_BPD_CSH_ORDER_UV sta

76:
77: -- Get the count of orders with highest sequence less than the given seq
78: CURSOR c_csh_ordr_countless (l_sequence_number IN NUMBER) IS
79: SELECT count(*) COUNT
80: FROM OKL_BPD_CSH_ORDER_UV sta
81: WHERE sta.SEQUENCE_NUMBER <= l_sequence_number
82: --------------------------------------------------------------------------------------
83: AND sta.ORG_ID = OKL_CONTEXT.get_okc_org_id; --dkagrawa changed for MOAC -- multi org compliant
84: --------------------------------------------------------------------------------------

Line 104: FROM OKL_BPD_CSH_ORDER_UV sta

100: -- Get the count of orders with sequence number greater than highest sequence
101: -- less than given seq
102: CURSOR c_csh_ordr_seqgreat_count (l_sequence_number IN NUMBER) IS
103: SELECT count(*) COUNT
104: FROM OKL_BPD_CSH_ORDER_UV sta
105: WHERE SEQUENCE_NUMBER > l_sequence_number
106: --------------------------------------------------------------------------------------
107: AND sta.ORG_ID = OKL_CONTEXT.get_okc_org_id; --dkagrawa changed for MOAC -- multi org compliant
108: --------------------------------------------------------------------------------------

Line 300: l_cshorder_sequence OKL_BPD_CSH_ORDER_UV.SEQUENCE_NUMBER%TYPE;

296: l_msg_count NUMBER;
297: l_msg_data VARCHAR2(2000);
298: i NUMBER;
299:
300: l_cshorder_sequence OKL_BPD_CSH_ORDER_UV.SEQUENCE_NUMBER%TYPE;
301: l_cshorder_seqmax OKL_BPD_CSH_ORDER_UV.SEQUENCE_NUMBER%TYPE;
302: l_cat_id OKL_BPD_CSH_ORDER_UV.CAT_ID%TYPE;
303: l_countless INTEGER;
304: l_newrownum INTEGER;

Line 301: l_cshorder_seqmax OKL_BPD_CSH_ORDER_UV.SEQUENCE_NUMBER%TYPE;

297: l_msg_data VARCHAR2(2000);
298: i NUMBER;
299:
300: l_cshorder_sequence OKL_BPD_CSH_ORDER_UV.SEQUENCE_NUMBER%TYPE;
301: l_cshorder_seqmax OKL_BPD_CSH_ORDER_UV.SEQUENCE_NUMBER%TYPE;
302: l_cat_id OKL_BPD_CSH_ORDER_UV.CAT_ID%TYPE;
303: l_countless INTEGER;
304: l_newrownum INTEGER;
305: l_count INTEGER;

Line 302: l_cat_id OKL_BPD_CSH_ORDER_UV.CAT_ID%TYPE;

298: i NUMBER;
299:
300: l_cshorder_sequence OKL_BPD_CSH_ORDER_UV.SEQUENCE_NUMBER%TYPE;
301: l_cshorder_seqmax OKL_BPD_CSH_ORDER_UV.SEQUENCE_NUMBER%TYPE;
302: l_cat_id OKL_BPD_CSH_ORDER_UV.CAT_ID%TYPE;
303: l_countless INTEGER;
304: l_newrownum INTEGER;
305: l_count INTEGER;
306: currseq INTEGER;

Line 335: --FROM OKL_BPD_CSH_ORDER_UV

331: -- Get all the orders for update
332: CURSOR c_csh_ordr_seq_all(l_cat_id IN NUMBER) IS
333: SELECT SEQUENCE_NUMBER, ID
334: FROM OKL_STRM_TYP_ALLOCS
335: --FROM OKL_BPD_CSH_ORDER_UV
336: WHERE STREAM_ALLC_TYPE = 'ODD'
337: ------------------------------
338: AND CAT_ID = l_cat_id
339: ------------------------------

Line 786: l_cshorder_sequence OKL_BPD_CSH_ORDER_UV.SEQUENCE_NUMBER%TYPE;

782: l_msg_count NUMBER;
783: l_msg_data VARCHAR2(2000);
784: i NUMBER;
785:
786: l_cshorder_sequence OKL_BPD_CSH_ORDER_UV.SEQUENCE_NUMBER%TYPE;
787: l_cshorder_seqmax OKL_BPD_CSH_ORDER_UV.SEQUENCE_NUMBER%TYPE;
788: l_cat_id OKL_BPD_CSH_ORDER_UV.CAT_ID%TYPE;
789: l_countless INTEGER;
790: l_newrownum INTEGER;

Line 787: l_cshorder_seqmax OKL_BPD_CSH_ORDER_UV.SEQUENCE_NUMBER%TYPE;

783: l_msg_data VARCHAR2(2000);
784: i NUMBER;
785:
786: l_cshorder_sequence OKL_BPD_CSH_ORDER_UV.SEQUENCE_NUMBER%TYPE;
787: l_cshorder_seqmax OKL_BPD_CSH_ORDER_UV.SEQUENCE_NUMBER%TYPE;
788: l_cat_id OKL_BPD_CSH_ORDER_UV.CAT_ID%TYPE;
789: l_countless INTEGER;
790: l_newrownum INTEGER;
791: l_count INTEGER;

Line 788: l_cat_id OKL_BPD_CSH_ORDER_UV.CAT_ID%TYPE;

784: i NUMBER;
785:
786: l_cshorder_sequence OKL_BPD_CSH_ORDER_UV.SEQUENCE_NUMBER%TYPE;
787: l_cshorder_seqmax OKL_BPD_CSH_ORDER_UV.SEQUENCE_NUMBER%TYPE;
788: l_cat_id OKL_BPD_CSH_ORDER_UV.CAT_ID%TYPE;
789: l_countless INTEGER;
790: l_newrownum INTEGER;
791: l_count INTEGER;
792: currseq INTEGER;

Line 948: l_cat_id OKL_BPD_CSH_ORDER_UV.CAT_ID%TYPE;

944: l_return_status VARCHAR2(1);
945: l_msg_count NUMBER;
946: l_msg_data VARCHAR2(2000);
947:
948: l_cat_id OKL_BPD_CSH_ORDER_UV.CAT_ID%TYPE;
949:
950: i NUMBER;
951: l_rownum INTEGER :=1;
952: l_count INTEGER;

Line 1106: l_cshorder_sequence OKL_BPD_CSH_ORDER_UV.SEQUENCE_NUMBER%TYPE;

1102: l_msg_count NUMBER;
1103: l_msg_data VARCHAR2(2000);
1104: i NUMBER;
1105:
1106: l_cshorder_sequence OKL_BPD_CSH_ORDER_UV.SEQUENCE_NUMBER%TYPE;
1107: l_cshorder_seqmax OKL_BPD_CSH_ORDER_UV.SEQUENCE_NUMBER%TYPE;
1108: l_countless INTEGER;
1109: l_newrownum INTEGER;
1110: l_count INTEGER;

Line 1107: l_cshorder_seqmax OKL_BPD_CSH_ORDER_UV.SEQUENCE_NUMBER%TYPE;

1103: l_msg_data VARCHAR2(2000);
1104: i NUMBER;
1105:
1106: l_cshorder_sequence OKL_BPD_CSH_ORDER_UV.SEQUENCE_NUMBER%TYPE;
1107: l_cshorder_seqmax OKL_BPD_CSH_ORDER_UV.SEQUENCE_NUMBER%TYPE;
1108: l_countless INTEGER;
1109: l_newrownum INTEGER;
1110: l_count INTEGER;
1111: currseq INTEGER;