APPS.PA_CI_SUPPLIER_UTILS dependencies on PA_CI_SUPPLIER_PKG

Line 690: PA_CI_SUPPLIER_PKG.insert_row (

686: If p_RECORD_STATUS(i) = 'NEW' then
687: If l_debug_mode = 'Y' THEN
688: print_msg('calling insert_row api');
689: End If;
690: PA_CI_SUPPLIER_PKG.insert_row (
691: x_rowid => l_rowid(i)
692: ,x_ci_transaction_id => l_ci_transaction_id(i)
693: ,p_CI_TYPE_ID => p_ci_type_id(i)
694: ,p_CI_ID => p_CI_ID(i)

Line 751: PA_CI_SUPPLIER_PKG.update_row (

747: Elsif p_RECORD_STATUS(i) = 'CHANGED' then
748: If l_debug_mode = 'Y' THEN
749: print_msg('calling update row api');
750: End If;
751: PA_CI_SUPPLIER_PKG.update_row (
752: p_rowid => l_rowid(i)
753: ,p_ci_transaction_id => l_ci_transaction_id(i)
754: ,p_CI_TYPE_ID => p_ci_type_id(i)
755: ,p_CI_ID => p_CI_ID(i)

Line 1018: PA_CI_SUPPLIER_PKG.insert_row (

1014: IF l_debug_mode = 'Y' THEN
1015: print_msg('calling insert_row api');
1016: End If;
1017:
1018: PA_CI_SUPPLIER_PKG.insert_row (
1019: x_rowid => l_rowid
1020: ,x_ci_transaction_id => l_ci_transaction_id
1021: ,p_CI_TYPE_ID => p_ci_type_id
1022: ,p_CI_ID => p_CI_ID

Line 1087: PA_CI_SUPPLIER_PKG.update_row (

1083: IF l_debug_mode = 'Y' THEN
1084: print_msg('calling update row api');
1085: End If;
1086:
1087: PA_CI_SUPPLIER_PKG.update_row (
1088: p_rowid => l_rowid
1089: ,p_ci_transaction_id => l_ci_transaction_id
1090: ,p_CI_TYPE_ID => p_ci_type_id
1091: ,p_CI_ID => p_CI_ID

Line 1137: PA_CI_SUPPLIER_PKG.insert_row (

1133: IF l_debug_mode = 'Y' THEN
1134: print_msg('calling insert_row api for record status CHANGED');
1135: End If;
1136:
1137: PA_CI_SUPPLIER_PKG.insert_row (
1138: x_rowid => l_rowid
1139: ,x_ci_transaction_id => l_ci_transaction_id
1140: ,p_CI_TYPE_ID => p_ci_type_id
1141: ,p_CI_ID => p_CI_ID

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

1285: X_MSG_COUNT := 0;
1286:
1287: If nvl(P_CI_TRANSACTION_ID ,0) <> 0 then
1288:
1289: PA_CI_SUPPLIER_PKG.delete_row (p_ci_transaction_id => P_CI_TRANSACTION_ID);
1290: /** issuing commit to prevent rollack issued by checkErrors method from java calls**/
1291: commit;
1292:
1293: End if;

Line 1788: PA_CI_SUPPLIER_PKG.delete_row (p_ci_transaction_id => p_ci_transaction_id_tbl(i));

1784: END IF;
1785:
1786: if (p_ci_transaction_id_tbl.count > 0) then
1787: for i in p_ci_transaction_id_tbl.first..p_ci_transaction_id_tbl.last loop
1788: PA_CI_SUPPLIER_PKG.delete_row (p_ci_transaction_id => p_ci_transaction_id_tbl(i));
1789: end loop;
1790:
1791: open get_project_id;
1792: fetch get_project_id into l_project_id;

Line 2111: PA_CI_SUPPLIER_PKG.insert_row (

2107: RAISE PA_API.G_EXCEPTION_ERROR;
2108: END IF;
2109: end if;
2110:
2111: PA_CI_SUPPLIER_PKG.insert_row (
2112: x_rowid => l_rowid
2113: ,x_ci_transaction_id => l_ci_transaction_id
2114: ,p_CI_TYPE_ID => l_ci_type_id
2115: ,p_CI_ID => l_ci_id

Line 2244: PA_CI_SUPPLIER_PKG.update_row (

2240: end if;
2241:
2242: end if;
2243:
2244: PA_CI_SUPPLIER_PKG.update_row (
2245: p_rowid => l_rowid
2246: ,p_ci_transaction_id => l_ci_transaction_id
2247: ,p_CI_TYPE_ID => l_ci_type_id
2248: ,p_CI_ID => l_ci_id