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.IGI_STP_NET_DOC_PKG dependencies on IGI_STP_CANDIDATES

Line 30: from igi_stp_candidates

26: /* If the user has left the reference fields blank we assume they are using min/max, */
27:
28: CURSOR trx_min (p_stp_id in number, p_application in varchar2) IS
29: SELECT min(trx_number)
30: from igi_stp_candidates
31: where stp_id = p_stp_id
32: and application = p_application
33: and user_id = x_user_id
34: and currency_code = x_currency_code ;

Line 38: from igi_stp_candidates

34: and currency_code = x_currency_code ;
35:
36: CURSOR trx_max(p_stp_id in number, p_application in varchar2) IS
37: SELECT max(trx_number)
38: from igi_stp_candidates
39: where stp_id = p_stp_id
40: and application = p_application
41: and user_id = x_user_id
42: and currency_code = x_currency_code;

Line 46: from igi_stp_candidates a

42: and currency_code = x_currency_code;
43:
44: /* CURSOR ref_min IS
45: SELECT min(a.reference)
46: from igi_stp_candidates a
47: where a.stp_id = x_vendor_id
48: and a.application = 'AP'
49: and a.user_id = x_user_id
50: and a.currency_code = x_currency_code

Line 51: and a.reference in ( select b.reference from igi_stp_candidates b

47: where a.stp_id = x_vendor_id
48: and a.application = 'AP'
49: and a.user_id = x_user_id
50: and a.currency_code = x_currency_code
51: and a.reference in ( select b.reference from igi_stp_candidates b
52: where b.stp_id = x_customer_id
53: and b.application = 'AR'
54: and b.user_id = x_user_id
55: and b.currency_code = x_currency_code);

Line 59: from igi_stp_candidates a

55: and b.currency_code = x_currency_code);
56:
57: CURSOR ref_max IS
58: SELECT max(a.reference)
59: from igi_stp_candidates a
60: where a.stp_id = x_vendor_id
61: and a.application = 'AP'
62: and a.user_id = x_user_id
63: and a.currency_code = x_currency_code

Line 64: and a.reference in ( select b.reference from igi_stp_candidates b

60: where a.stp_id = x_vendor_id
61: and a.application = 'AP'
62: and a.user_id = x_user_id
63: and a.currency_code = x_currency_code
64: and a.reference in ( select b.reference from igi_stp_candidates b
65: where b.stp_id = x_customer_id
66: and b.application = 'AR'
67: and b.user_id = x_user_id
68: and b.currency_code = x_currency_code);

Line 77: FROM igi_stp_candidates p

73: ,p_ref_max in varchar2
74: ,l_ref_min in varchar2
75: ,l_ref_max in varchar2) IS
76: SELECT distinct p.reference
77: FROM igi_stp_candidates p
78: WHERE p.application = 'AP'
79: AND p.user_id = x_user_id
80: AND p.stp_id = x_vendor_id
81: AND p.currency_code = x_currency_code

Line 85: FROM igi_stp_candidates r

81: AND p.currency_code = x_currency_code
82: AND p.reference >= nvl(p_ref_min, l_ref_min)
83: AND p.reference <= nvl(p_ref_max, l_ref_max)
84: AND p.reference IN (SELECT distinct r.reference
85: FROM igi_stp_candidates r
86: WHERE application = 'AR'
87: AND r.user_id = x_user_id
88: AND r.stp_id = x_customer_id
89: AND r.currency_code = x_currency_code

Line 101: UPDATE igi_stp_candidates

97: BEGIN
98:
99: /* Depending on the Netting Type only certain documents are selected either AP and AR, AP or AR */
100:
101: UPDATE igi_stp_candidates
102: SET process_flag = 'R'
103: WHERE user_id = x_user_id
104: and stp_id in (x_customer_id, x_vendor_id)
105: and currency_code = x_currency_code;

Line 122: UPDATE igi_stp_candidates

118: OPEN trx_max(x_vendor_id, 'AP');
119: FETCH trx_max INTO v_ap_trx_max;
120: CLOSE trx_max;
121:
122: UPDATE igi_stp_candidates
123: SET process_flag = 'A'
124: WHERE user_id = x_user_id
125: and stp_id = x_vendor_id
126: and currency_code = x_currency_code

Line 141: UPDATE igi_stp_candidates

137: OPEN trx_max(x_customer_id, 'AR');
138: FETCH trx_max INTO v_ar_trx_max;
139: CLOSE trx_max;
140:
141: UPDATE igi_stp_candidates
142: SET process_flag = 'A'
143: WHERE user_id = x_user_id
144: and stp_id = x_customer_id
145: and currency_code = x_currency_code

Line 162: UPDATE igi_stp_candidates

158: CLOSE ref_max;
159:
160: for rec_match in matched_ref(x_ref_min, x_ref_max,
161: v_ref_min, v_ref_max) loop
162: UPDATE igi_stp_candidates
163: SET process_flag = 'A'
164: -- Bug 1322996
165: -- SET process_flag = 'S'
166: -- , package_num = x_counter

Line 186: UPDATE igi_stp_candidates

182: OPEN trx_max(x_vendor_id, 'AP');
183: FETCH trx_max INTO v_ap_trx_max;
184: CLOSE trx_max;
185:
186: UPDATE igi_stp_candidates
187: SET process_flag = 'A'
188: WHERE user_id = x_user_id
189: and stp_id = x_vendor_id
190: and currency_code = x_currency_code

Line 207: UPDATE igi_stp_candidates

203: OPEN trx_max(x_customer_id, 'AR');
204: FETCH trx_max INTO v_ar_trx_max;
205: CLOSE trx_max;
206:
207: UPDATE igi_stp_candidates
208: SET process_flag = 'A'
209: WHERE user_id = x_user_id
210: and stp_id = x_customer_id
211: and currency_code = x_currency_code

Line 232: UPDATE igi_stp_candidates_all

228: BEGIN
229:
230:
231:
232: UPDATE igi_stp_candidates_all
233: SET batch_id = x_batch_id
234: , netting_trx_type_id = x_type
235: , package_id = x_package_id
236: WHERE user_id = x_user_id