DBA Data[Home] [Help]

APPS.OKS_IMPORT_INSERT dependencies on OKC_CONTACTS

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

1000:
1001: --========================================================================
1002: -- PROCEDURE : Insert_Contacts PRIVATE
1003: -- PARAMETERS:
1004: -- COMMENT : This procedure will insert into Okc Contacts
1005: --=========================================================================
1006:
1007: PROCEDURE Insert_Contacts
1008: IS

Line 1024: INTO OKC_CONTACTS

1020: l_stmt_num := 10;
1021:
1022: INSERT ALL
1023: WHEN (CUSTOMER_CONTRACT_ADMIN_ID IS NOT NULL ) THEN
1024: INTO OKC_CONTACTS
1025: (ID
1026: ,CPL_ID
1027: ,CRO_CODE
1028: ,DNZ_CHR_ID

Line 1079: INTO OKC_CONTACTS

1075: l_stmt_num := 20;
1076:
1077: INSERT ALL
1078: WHEN (SALESPERSON_ID IS NOT NULL ) THEN
1079: INTO OKC_CONTACTS
1080: (ID
1081: ,CPL_ID
1082: ,CRO_CODE
1083: ,DNZ_CHR_ID

Line 1137: INTO OKC_CONTACTS

1133: l_stmt_num := 25;
1134:
1135: INSERT ALL
1136: WHEN (CUSTOMER_BILLING_CONTACT_ID is not null ) THEN
1137: INTO OKC_CONTACTS
1138: (ID
1139: ,CPL_ID
1140: ,CRO_CODE
1141: ,DNZ_CHR_ID

Line 1165: INTO OKC_CONTACTS

1161: ,LAST_UPDATED_BY
1162: ,LAST_UPDATE_DATE
1163: ,LAST_UPDATE_LOGIN )
1164: WHEN (CUSTOMER_SHIPPING_CONTACT_ID is not null ) THEN
1165: INTO OKC_CONTACTS
1166: (ID
1167: ,CPL_ID
1168: ,CRO_CODE
1169: ,DNZ_CHR_ID

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

1254:
1255: --========================================================================
1256: -- PROCEDURE : Insert_Sales_Credits PRIVATE
1257: -- PARAMETERS:
1258: -- COMMENT : This procedure will insert into Okc Contacts
1259: --=========================================================================
1260:
1261: PROCEDURE Insert_Sales_Credits
1262: IS