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.

[Home] [Help]

APPS.POS_SBD_TBL_PKG dependencies on POS_ACNT_ADDR_REQ

Line 30: PROCEDURE del_row_pos_acnt_addr_req (

26: x_exception_msg := 'Failure at step ' || l_step || Sqlerrm;
27: raise_application_error(-20043, x_exception_msg, true);
28: END del_row_pos_acnt_summ_req;
29:
30: PROCEDURE del_row_pos_acnt_addr_req (
31: p_assignment_request_id IN NUMBER
32: , x_status out nocopy VARCHAR2
33: , x_exception_msg out nocopy VARCHAR2
34: )

Line 43: delete from pos_acnt_addr_req where assignment_request_id = p_assignment_request_id;

39: BEGIN
40:
41: l_step := 0;
42:
43: delete from pos_acnt_addr_req where assignment_request_id = p_assignment_request_id;
44:
45: l_step := 1;
46:
47: x_status := 'S';

Line 54: END del_row_pos_acnt_addr_req;

50: WHEN OTHERS THEN
51: X_STATUS :='E';
52: x_exception_msg := 'Failure at step ' || l_step || Sqlerrm;
53: raise_application_error(-20045, x_exception_msg, true);
54: END del_row_pos_acnt_addr_req;
55:
56: PROCEDURE del_row_pos_acnt_gen_req (
57: p_account_request_id IN NUMBER
58: , x_status out nocopy VARCHAR2

Line 127: /* This procedure create a row in POS_ACNT_ADDR_REQ

123: raise_application_error(-20046, x_exception_msg, true);
124: END update_row_pos_acnt_summ_req;
125:
126:
127: /* This procedure create a row in POS_ACNT_ADDR_REQ
128: *
129: */
130: PROCEDURE insert_row_pos_acnt_addr_req (
131: p_mapping_id in NUMBER

Line 130: PROCEDURE insert_row_pos_acnt_addr_req (

126:
127: /* This procedure create a row in POS_ACNT_ADDR_REQ
128: *
129: */
130: PROCEDURE insert_row_pos_acnt_addr_req (
131: p_mapping_id in NUMBER
132: , p_request_type in varchar2
133: , p_party_site_id in number
134: , p_address_request_id in number

Line 146: select POS_ACNT_ADDR_REQ_S.nextval into x_assignment_request_id from dual;

142:
143: BEGIN
144:
145: l_step := 0;
146: select POS_ACNT_ADDR_REQ_S.nextval into x_assignment_request_id from dual;
147:
148: l_step := 1;
149: insert into POS_ACNT_ADDR_REQ (
150: assignment_request_id

Line 149: insert into POS_ACNT_ADDR_REQ (

145: l_step := 0;
146: select POS_ACNT_ADDR_REQ_S.nextval into x_assignment_request_id from dual;
147:
148: l_step := 1;
149: insert into POS_ACNT_ADDR_REQ (
150: assignment_request_id
151: , creation_date
152: , created_by
153: , last_update_date

Line 188: END insert_row_pos_acnt_addr_req;

184: WHEN OTHERS THEN
185: X_STATUS :='E';
186: x_exception_msg := 'Failure at step ' || l_step || Sqlerrm;
187: raise_application_error(-20048, x_exception_msg, true);
188: END insert_row_pos_acnt_addr_req;
189:
190:
191: /* This procedure create a row in POS_ACNT_GEN_REQ
192: *

Line 316: /* This procedure updates a row in POS_ACNT_ADDR_REQ

312: raise_application_error(-20049, x_exception_msg, true);
313: END insert_row_pos_acnt_summ_req;
314:
315:
316: /* This procedure updates a row in POS_ACNT_ADDR_REQ
317: *
318: */
319: PROCEDURE update_row_pos_acnt_addr_req (
320: p_assignment_request_id IN NUMBER

Line 319: PROCEDURE update_row_pos_acnt_addr_req (

315:
316: /* This procedure updates a row in POS_ACNT_ADDR_REQ
317: *
318: */
319: PROCEDURE update_row_pos_acnt_addr_req (
320: p_assignment_request_id IN NUMBER
321: , p_request_status in varchar2
322: , p_party_site_id in number
323: , p_address_request_id in number

Line 333: select object_version_number from POS_ACNT_ADDR_REQ

329: l_step number;
330: l_object_version_number number;
331:
332: cursor l_update_cur is
333: select object_version_number from POS_ACNT_ADDR_REQ
334: where assignment_request_id = p_assignment_request_id for update;
335:
336: BEGIN
337:

Line 349: update POS_ACNT_ADDR_REQ set

345:
346: if l_object_version_number = p_object_version_number then
347:
348: l_step := 2;
349: update POS_ACNT_ADDR_REQ set
350: last_update_date = sysdate
351: , last_updated_by = fnd_global.user_id
352: , last_update_login = fnd_global.login_id
353: , request_status = nvl(p_request_status, request_status)

Line 374: END update_row_pos_acnt_addr_req;

370: WHEN OTHERS THEN
371: X_STATUS :='E';
372: x_exception_msg := 'Failure at step ' || l_step || Sqlerrm;
373: raise_application_error(-20049, x_exception_msg, true);
374: END update_row_pos_acnt_addr_req;
375:
376: END POS_SBD_TBL_PKG;