APPS.POS_SBD_TBL_PKG dependencies on POS_ACNT_GEN_REQ

Line 56: PROCEDURE del_row_pos_acnt_gen_req (

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
59: , x_exception_msg out nocopy VARCHAR2
60: )

Line 69: delete from pos_acnt_gen_req where account_request_id = p_account_request_id;

65: BEGIN
66:
67: l_step := 0;
68:
69: delete from pos_acnt_gen_req where account_request_id = p_account_request_id;
70:
71: l_step := 1;
72:
73: x_status := 'S';

Line 80: END del_row_pos_acnt_gen_req;

76: WHEN OTHERS THEN
77: X_STATUS :='E';
78: x_exception_msg := 'Failure at step ' || l_step || Sqlerrm;
79: raise_application_error(-20049, x_exception_msg, true);
80: END del_row_pos_acnt_gen_req;
81:
82: PROCEDURE update_row_pos_acnt_summ_req (
83: p_assignment_id IN NUMBER
84: , p_assignment_request_id IN NUMBER

Line 191: /* This procedure create a row in POS_ACNT_GEN_REQ

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: *
193: */
194: PROCEDURE insert_row_pos_acnt_gen_req (
195: p_mapping_id IN NUMBER

Line 194: PROCEDURE insert_row_pos_acnt_gen_req (

190:
191: /* This procedure create a row in POS_ACNT_GEN_REQ
192: *
193: */
194: PROCEDURE insert_row_pos_acnt_gen_req (
195: p_mapping_id IN NUMBER
196: , p_temp_ext_bank_account_id IN NUMBER
197: , p_ext_bank_account_id IN NUMBER
198: , x_account_request_id out nocopy number

Line 209: select POS_ACNT_GEN_REQ_S.nextval into x_account_request_id from dual;

205:
206: BEGIN
207:
208: l_step := 0;
209: select POS_ACNT_GEN_REQ_S.nextval into x_account_request_id from dual;
210:
211: l_step := 1;
212: insert into POS_ACNT_GEN_REQ (
213: account_request_id

Line 212: insert into POS_ACNT_GEN_REQ (

208: l_step := 0;
209: select POS_ACNT_GEN_REQ_S.nextval into x_account_request_id from dual;
210:
211: l_step := 1;
212: insert into POS_ACNT_GEN_REQ (
213: account_request_id
214: , creation_date
215: , created_by
216: , last_update_date

Line 247: END insert_row_pos_acnt_gen_req;

243: WHEN OTHERS THEN
244: X_STATUS :='E';
245: x_exception_msg := 'Failure at step ' || l_step || Sqlerrm;
246: raise_application_error(-20047, x_exception_msg, true);
247: END insert_row_pos_acnt_gen_req;
248:
249: PROCEDURE insert_row_pos_acnt_summ_req (
250: p_assignment_request_id in number
251: , p_ext_bank_account_id IN NUMBER