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_CONTEXT

Line 64: AND sta.ORG_ID = OKL_CONTEXT.get_okc_org_id --dkagrawa changed for MOAC -- multi org compliant

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: ------------------------------------------------------------------------------------
66: ORDER BY SEQUENCE_NUMBER;
67:
68: -- Get the count of total orders

Line 73: WHERE sta.ORG_ID = OKL_CONTEXT.get_okc_org_id; --dkagrawa changed for MOAC -- multi org compliant

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:
76:
77: -- Get the count of orders with highest sequence less than the given seq

Line 83: AND sta.ORG_ID = OKL_CONTEXT.get_okc_org_id; --dkagrawa changed for MOAC -- multi org compliant

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: --------------------------------------------------------------------------------------
85:
86: -- Get the orders with sequence number greater than highest sequence
87: -- less than given seq

Line 107: AND sta.ORG_ID = OKL_CONTEXT.get_okc_org_id; --dkagrawa changed for MOAC -- multi org compliant

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: --------------------------------------------------------------------------------------
109:
110: c_csh_ordr_seq_rec c_csh_ordr_seq%ROWTYPE;
111: c_csh_ordr_count_rec c_csh_ordr_count%ROWTYPE;