APPS.IBE_PAYMENT_INT_PVT dependencies on IBE_ORD_ONECLICK

Line 72: from ibe_ord_oneclick

68: Cursor c_get_oneclick_settings(c_party_id IN NUMBER,
69: c_cust_id IN NUMBER) is
70:
71: select ord_oneclick_id, enabled_flag
72: from ibe_ord_oneclick
73: where party_id = c_party_id and cust_account_id = c_cust_id;
74:
75: rec_check_address_owner c_check_address_owner%rowtype;
76:

Line 437: IBE_UTIL.debug('call process_credit_card - Going to call ibe_ord_oneclick_pvt.Update_Settings()');

433: END IF;
434:
435: IF l_oneclick_id <> FND_API.g_miss_num and l_enabled_flag = 'Y' then
436: IF (l_debugon = l_true) THEN
437: IBE_UTIL.debug('call process_credit_card - Going to call ibe_ord_oneclick_pvt.Update_Settings()');
438: IBE_UTIL.debug('call process_credit_card - p_party_id ' ||p_party_id);
439: IBE_UTIL.debug('call process_credit_card - p_cust_id '||p_cust_id);
440: IBE_UTIL.debug('call process_credit_card - p_assignment_id'||l_assignment_attr.Assignment_Id);
441: END IF;

Line 443: ibe_ord_oneclick_pvt.Update_Settings(

439: IBE_UTIL.debug('call process_credit_card - p_cust_id '||p_cust_id);
440: IBE_UTIL.debug('call process_credit_card - p_assignment_id'||l_assignment_attr.Assignment_Id);
441: END IF;
442:
443: ibe_ord_oneclick_pvt.Update_Settings(
444: p_api_version => p_api_version
445: ,p_init_msg_list => p_init_msg_list
446: ,p_commit => p_commit
447: ,x_return_status => x_return_status

Line 695: FROM ibe_ord_oneclick_all;

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

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

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

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

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

Line 820: UPDATE IBE_ORD_ONECLICK_ALL

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