APPS.PA_CI_SUPPLIER_UTILS dependencies on PA_CI_SUPPLIER_PKG

Line 459: PA_CI_SUPPLIER_PKG.insert_row (

455: If p_RECORD_STATUS(i) = 'NEW' then
456: If l_debug_mode = 'Y' THEN
457: print_msg('calling insert_row api');
458: End If;
459: PA_CI_SUPPLIER_PKG.insert_row (
460: x_rowid => l_rowid(i)
461: ,x_ci_transaction_id => l_ci_transaction_id(i)
462: ,p_CI_TYPE_ID => p_ci_type_id(i)
463: ,p_CI_ID => p_CI_ID(i)

Line 498: PA_CI_SUPPLIER_PKG.update_row (

494: Elsif p_RECORD_STATUS(i) = 'CHANGED' then
495: If l_debug_mode = 'Y' THEN
496: print_msg('calling update row api');
497: End If;
498: PA_CI_SUPPLIER_PKG.update_row (
499: p_rowid => l_rowid(i)
500: ,p_ci_transaction_id => l_ci_transaction_id(i)
501: ,p_CI_TYPE_ID => p_ci_type_id(i)
502: ,p_CI_ID => p_CI_ID(i)

Line 667: PA_CI_SUPPLIER_PKG.insert_row (

663: If p_RECORD_STATUS = 'NEW' then
664: IF l_debug_mode = 'Y' THEN
665: print_msg('calling insert_row api');
666: End If;
667: PA_CI_SUPPLIER_PKG.insert_row (
668: x_rowid => l_rowid
669: ,x_ci_transaction_id => l_ci_transaction_id
670: ,p_CI_TYPE_ID => p_ci_type_id
671: ,p_CI_ID => p_CI_ID

Line 737: PA_CI_SUPPLIER_PKG.update_row (

733: If check_trx_exists(l_ci_transaction_id) = 'Y' then
734: IF l_debug_mode = 'Y' THEN
735: print_msg('calling update row api');
736: End If;
737: PA_CI_SUPPLIER_PKG.update_row (
738: p_rowid => l_rowid
739: ,p_ci_transaction_id => l_ci_transaction_id
740: ,p_CI_TYPE_ID => p_ci_type_id
741: ,p_CI_ID => p_CI_ID

Line 764: PA_CI_SUPPLIER_PKG.insert_row (

760: Else
761: IF l_debug_mode = 'Y' THEN
762: print_msg('calling insert_row api for record status CHANGED');
763: End If;
764: PA_CI_SUPPLIER_PKG.insert_row (
765: x_rowid => l_rowid
766: ,x_ci_transaction_id => l_ci_transaction_id
767: ,p_CI_TYPE_ID => p_ci_type_id
768: ,p_CI_ID => p_CI_ID

Line 894: PA_CI_SUPPLIER_PKG.delete_row (p_ci_transaction_id => P_CI_TRANSACTION_ID);

890: X_MSG_COUNT := 0;
891:
892: If nvl(P_CI_TRANSACTION_ID ,0) <> 0 then
893:
894: PA_CI_SUPPLIER_PKG.delete_row (p_ci_transaction_id => P_CI_TRANSACTION_ID);
895: /** issuing commit to prevent rollack issued by checkErrors method from java calls**/
896: commit;
897:
898: End if;