APPS.PA_CI_SUPPLIER_UTILS dependencies on PA_CI_SUPPLIER_DETAILS

Line 14: /** This API checks whether the record exists or not in pa_ci_supplier_details **/

10: NULL;
11:
12: END print_msg;
13:
14: /** This API checks whether the record exists or not in pa_ci_supplier_details **/
15: FUNCTION check_trx_exists(p_ci_transaction_id in NUMBER)
16: RETURN VARCHAR2 IS
17: l_return_status varchar2(1) := 'N';
18: BEGIN

Line 24: FROM pa_ci_supplier_details

20: IF p_ci_transaction_id is NOT NULL then
21:
22: SELECT 'Y'
23: INTO l_return_status
24: FROM pa_ci_supplier_details
25: WHERE ci_transaction_id = p_ci_transaction_id;
26:
27: ELSE
28: l_return_status := 'N';

Line 945: INSERT INTO PA_CI_SUPPLIER_DETAILS

941:
942: IF p_from_ci_item_id is NOT NULL and
943: p_to_ci_item_id is NOT NULL Then
944:
945: INSERT INTO PA_CI_SUPPLIER_DETAILS
946: (
947: CI_TRANSACTION_ID
948: ,CI_TYPE_ID
949: ,CI_ID

Line 966: PA_CI_SUPPLIER_DETAILS_S.nextval

962: ,LAST_UPDATE_DATE
963: ,LAST_UPDATE_LOGIN
964: )
965: SELECT
966: PA_CI_SUPPLIER_DETAILS_S.nextval
967: ,ci.CI_TYPE_ID
968: ,p_to_ci_item_id
969: ,si.CI_IMPACT_ID
970: ,si.VENDOR_ID

Line 983: FROM PA_CI_SUPPLIER_DETAILS si

979: ,sysdate
980: ,NVL(FND_GLOBAL.login_id,-99)
981: ,sysdate
982: ,NVL(FND_GLOBAL.login_id,-99)
983: FROM PA_CI_SUPPLIER_DETAILS si
984: ,PA_CONTROL_ITEMS ci
985: WHERE si.CI_ID = p_from_ci_item_id
986: AND ci.ci_id = p_to_ci_item_id;
987:

Line 1029: DELETE FROM PA_CI_SUPPLIER_DETAILS

1025: x_MSG_DATA := null;
1026: X_MSG_COUNT := 0;
1027:
1028: If nvl(p_ci_id ,0) <> 0 then
1029: DELETE FROM PA_CI_SUPPLIER_DETAILS
1030: WHERE ci_id = p_ci_id;
1031: commit;
1032:
1033: End if;

Line 1063: FROM pa_ci_supplier_details

1059: ) IS
1060:
1061: cursor c1 is
1062: SELECT CI_TRANSACTION_ID
1063: FROM pa_ci_supplier_details
1064: WHERE ci_id = p_ci_id;
1065:
1066: l_ci_transaction_id Number;
1067: l_msg_index_out Number;