APPS.WSH_SHIPMENT_ADVICE_PUB dependencies on WSH_DEL_ASSGN_INTERFACE

Line 1027: wsh_debug_sv.log(l_module_name, 'Inserting Records into WSH_DEL_ASSGN_INTERFACE.Number of Records',l_del_assgn_cnt);

1023: IF l_del_assgn_cnt > 0 THEN
1024:
1025:
1026: IF l_debug_on THEN
1027: wsh_debug_sv.log(l_module_name, 'Inserting Records into WSH_DEL_ASSGN_INTERFACE.Number of Records',l_del_assgn_cnt);
1028: END IF;
1029: IF l_del_assgn_cnt <4 THEN
1030:
1031: FOR I in 1..l_del_assgn_cnt LOOP

Line 1033: INSERT INTO WSH_DEL_ASSGN_INTERFACE(

1029: IF l_del_assgn_cnt <4 THEN
1030:
1031: FOR I in 1..l_del_assgn_cnt LOOP
1032:
1033: INSERT INTO WSH_DEL_ASSGN_INTERFACE(
1034: DEL_ASSGN_INTERFACE_ID,
1035: INTERFACE_ACTION_CODE,
1036: CREATION_DATE,
1037: CREATED_BY,

Line 1045: wsh_del_assgn_interface_s.nextval,

1041: DELIVERY_DETAIL_INTERFACE_ID ,
1042: DELIVERY_DETAIL_ID,
1043: PARENT_DELIVERY_DETAIL_ID)
1044: VALUES(
1045: wsh_del_assgn_interface_s.nextval,
1046: G_INTERFACE_ACTION_CODE,
1047: sysdate,
1048: FND_GLOBAL.USER_ID,
1049: sysdate,

Line 1062: INSERT INTO WSH_DEL_ASSGN_INTERFACE(

1058: ELSE
1059:
1060: FORALL I in 1..l_del_assgn_cnt
1061:
1062: INSERT INTO WSH_DEL_ASSGN_INTERFACE(
1063: DEL_ASSGN_INTERFACE_ID,
1064: INTERFACE_ACTION_CODE,
1065: CREATION_DATE,
1066: CREATED_BY,

Line 1074: wsh_del_assgn_interface_s.nextval,

1070: DELIVERY_DETAIL_INTERFACE_ID ,
1071: DELIVERY_DETAIL_ID,
1072: PARENT_DELIVERY_DETAIL_ID)
1073: VALUES(
1074: wsh_del_assgn_interface_s.nextval,
1075: G_INTERFACE_ACTION_CODE,
1076: sysdate,
1077: FND_GLOBAL.USER_ID,
1078: sysdate,