APPS.PAY_PSS_TX_STEPS_PKG dependencies on PAY_PSS_TRANSACTION_STEPS

Line 90: select pay_pss_transaction_steps_s.nextval

86: end if;
87: --
88: -- Create and return the transaction_step_id.
89: --
90: select pay_pss_transaction_steps_s.nextval
91: into l_transaction_step_id
92: from dual;
93: p_transaction_step_id := l_transaction_step_id;
94: --

Line 97: insert into pay_pss_transaction_steps

93: p_transaction_step_id := l_transaction_step_id;
94: --
95: -- Do the insert.
96: --
97: insert into pay_pss_transaction_steps
98: (transaction_step_id
99: ,transaction_id
100: ,source_table
101: ,state

Line 312: update pay_pss_transaction_steps p

308: ,p_o_attribute19 in varchar2
309: ,p_o_attribute20 in varchar2
310: ) is
311: begin
312: update pay_pss_transaction_steps p
313: set p.source_table = p_source_table
314: , p.state = p_state
315: , p.personal_payment_method_id = p_personal_payment_method_id
316: , p.update_ovn = p_update_ovn

Line 388: from pay_pss_transaction_steps

384: (p_transaction_step_id in number
385: ) is
386: begin
387: delete
388: from pay_pss_transaction_steps
389: where transaction_step_id = p_transaction_step_id;
390: end delete_row;
391: ---------------------------------< delete_rows >----------------------------
392: procedure delete_rows

Line 397: from pay_pss_transaction_steps

393: (p_transaction_id in number
394: ) is
395: begin
396: delete
397: from pay_pss_transaction_steps
398: where transaction_id = p_transaction_id;
399: end delete_rows;
400: --
401: end pay_pss_tx_steps_pkg;