APPS.IBE_PAYMENT_INT_PVT dependencies on IBE_ORD_ONECLICK_ALL

Line 693: FROM ibe_ord_oneclick_all;

689: l_oneclick_payment_id NUMBER(15);
690:
691: CURSOR c_oneclick_data is
692: SELECT payment_id, party_id, cust_account_id, org_id
693: FROM ibe_ord_oneclick_all;
694:
695: CURSOR c_assignment_data(c_pmt_id NUMBER,
696: c_party_id NUMBER,
697: c_org_id NUMBER,

Line 745: -- IBE_ORD_ONECLICK_ALL table currently stores the express checkout preferences. The preferred credit card is

741: print_debug_log(' start_time = ' ||to_char(sysdate,'DD-MON-RRRR HH24:MI:SS'));
742: END IF;
743: --l_msg_data populated with different event points
744:
745: -- IBE_ORD_ONECLICK_ALL table currently stores the express checkout preferences. The preferred credit card is
746: -- stored in the column payment_id. Going forward this column will store the assignment_id.
747: --1. Cursor query to retrive the records in the one click table
748:
749: FOR rec_oneclick_data in c_oneclick_data LOOP

Line 813: print_debug_log('Before updating IBE_ORD_ONECLICK_ALL');

809: -- because it might be assigned to the party or party-acct or party-org combinations.
810:
811: -- log old and new values before the update
812: IF l_iby_debug = 'T' THEN
813: print_debug_log('Before updating IBE_ORD_ONECLICK_ALL');
814: print_debug_log('Original payment id before update: '||l_oneclick_payment_id);
815: print_debug_log('New payment id(actually assignment_id) after update: '||l_instr_assignment_id);
816: END IF;
817:

Line 818: UPDATE IBE_ORD_ONECLICK_ALL

814: print_debug_log('Original payment id before update: '||l_oneclick_payment_id);
815: print_debug_log('New payment id(actually assignment_id) after update: '||l_instr_assignment_id);
816: END IF;
817:
818: UPDATE IBE_ORD_ONECLICK_ALL
819: SET PAYMENT_ID = l_instr_assignment_id
820: WHERE party_id = rec_oneclick_data.party_id
821: AND cust_account_id = rec_oneclick_data.cust_account_id
822: AND org_id = rec_oneclick_data.org_id;