DBA Data[Home] [Help]

APPS.OKS_IMPORT_INSERT dependencies on OKC_CONTACTS

Line 999: -- COMMENT : This procedure will insert into Okc Contacts

995:
996: --========================================================================
997: -- PROCEDURE : Insert_Contacts PRIVATE
998: -- PARAMETERS:
999: -- COMMENT : This procedure will insert into Okc Contacts
1000: --=========================================================================
1001:
1002: PROCEDURE Insert_Contacts
1003: IS

Line 1019: INTO OKC_CONTACTS

1015: l_stmt_num := 10;
1016:
1017: INSERT ALL
1018: WHEN (CUSTOMER_CONTRACT_ADMIN_ID IS NOT NULL ) THEN
1019: INTO OKC_CONTACTS
1020: (ID
1021: ,CPL_ID
1022: ,CRO_CODE
1023: ,DNZ_CHR_ID

Line 1074: INTO OKC_CONTACTS

1070: l_stmt_num := 20;
1071:
1072: INSERT ALL
1073: WHEN (SALESPERSON_ID IS NOT NULL ) THEN
1074: INTO OKC_CONTACTS
1075: (ID
1076: ,CPL_ID
1077: ,CRO_CODE
1078: ,DNZ_CHR_ID

Line 1132: INTO OKC_CONTACTS

1128: l_stmt_num := 25;
1129:
1130: INSERT ALL
1131: WHEN (CUSTOMER_BILLING_CONTACT_ID is not null ) THEN
1132: INTO OKC_CONTACTS
1133: (ID
1134: ,CPL_ID
1135: ,CRO_CODE
1136: ,DNZ_CHR_ID

Line 1160: INTO OKC_CONTACTS

1156: ,LAST_UPDATED_BY
1157: ,LAST_UPDATE_DATE
1158: ,LAST_UPDATE_LOGIN )
1159: WHEN (CUSTOMER_SHIPPING_CONTACT_ID is not null ) THEN
1160: INTO OKC_CONTACTS
1161: (ID
1162: ,CPL_ID
1163: ,CRO_CODE
1164: ,DNZ_CHR_ID

Line 1253: -- COMMENT : This procedure will insert into Okc Contacts

1249:
1250: --========================================================================
1251: -- PROCEDURE : Insert_Sales_Credits PRIVATE
1252: -- PARAMETERS:
1253: -- COMMENT : This procedure will insert into Okc Contacts
1254: --=========================================================================
1255:
1256: PROCEDURE Insert_Sales_Credits
1257: IS