APPS.PAY_PSS_TX_STEPS_PKG dependencies on PAY_PSS_TRANSACTION_STEPS

Line 152: select pay_pss_transaction_steps_s.nextval

148: end if;
149: --
150: -- Create and return the transaction_step_id.
151: --
152: select pay_pss_transaction_steps_s.nextval
153: into l_transaction_step_id
154: from dual;
155: p_transaction_step_id := l_transaction_step_id;
156: --

Line 159: insert into pay_pss_transaction_steps

155: p_transaction_step_id := l_transaction_step_id;
156: --
157: -- Do the insert.
158: --
159: insert into pay_pss_transaction_steps
160: (transaction_step_id
161: ,transaction_id
162: ,source_table
163: ,state

Line 560: update pay_pss_transaction_steps p

556: ,p_o_ppm_information29 in varchar2
557: ,p_o_ppm_information30 in varchar2
558: ) is
559: begin
560: update pay_pss_transaction_steps p
561: set p.source_table = p_source_table
562: , p.state = p_state
563: , p.personal_payment_method_id = p_personal_payment_method_id
564: , p.update_ovn = p_update_ovn

Line 698: from pay_pss_transaction_steps

694: (p_transaction_step_id in number
695: ) is
696: begin
697: delete
698: from pay_pss_transaction_steps
699: where transaction_step_id = p_transaction_step_id;
700: end delete_row;
701: ---------------------------------< delete_rows >----------------------------
702: procedure delete_rows

Line 707: from pay_pss_transaction_steps

703: (p_transaction_id in number
704: ) is
705: begin
706: delete
707: from pay_pss_transaction_steps
708: where transaction_id = p_transaction_id;
709: end delete_rows;
710: --
711: end pay_pss_tx_steps_pkg;