APPS.MSC_CL_OTHER_ODS_LOAD dependencies on MSC_SR_ASSIGNMENTS

Line 747: UPDATE MSC_SR_ASSIGNMENTS

743: END IF;
744:
745: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
746:
747: UPDATE MSC_SR_ASSIGNMENTS
748: SET DELETED_FLAG= MSC_UTIL.SYS_YES,
749: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
750: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
751: WHERE SR_ASSIGNMENT_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id

Line 808: UPDATE MSC_SR_ASSIGNMENTS msa

804: BEGIN
805:
806: FORALL j IN lb_SR_ASSIGNMENT_ID.FIRST..lb_SR_ASSIGNMENT_ID.LAST
807:
808: UPDATE MSC_SR_ASSIGNMENTS msa
809: SET msa.ASSIGNMENT_TYPE = lb_ASSIGNMENT_TYPE(j),
810: msa.SOURCING_RULE_ID = lb_SOURCING_RULE_ID(j),
811: msa.SOURCING_RULE_TYPE = lb_SOURCING_RULE_TYPE(j),
812: msa.INVENTORY_ITEM_ID = lb_INVENTORY_ITEM_ID(j),

Line 837: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_ASSIGNMENTS');

833:
834: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
835: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
836: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
837: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_ASSIGNMENTS');
838: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
839:
840: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
841: RAISE;

Line 850: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_ASSIGNMENTS');

846:
847: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
848: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
849: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
850: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_ASSIGNMENTS');
851: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
852:
853: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
854: END IF;

Line 866: INTO MSC_SR_ASSIGNMENTS

862: BEGIN
863:
864:
865: INSERT /*+ APPEND */
866: INTO MSC_SR_ASSIGNMENTS
867: ( ASSIGNMENT_ID,
868: SR_ASSIGNMENT_ID,
869: ASSIGNMENT_SET_ID,
870: ASSIGNMENT_TYPE,

Line 889: MSC_SR_ASSIGNMENTS_S.NEXTVAL,

885: LAST_UPDATED_BY,
886: CREATION_DATE,
887: CREATED_BY)
888: SELECT
889: MSC_SR_ASSIGNMENTS_S.NEXTVAL,
890: mssa.SR_ASSIGNMENT_ID,
891: mas.ASSIGNMENT_SET_ID,
892: mssa.ASSIGNMENT_TYPE,
893: msr.SOURCING_RULE_ID,

Line 953: from MSC_SR_ASSIGNMENTS msa2

949: OR
950: mssa.assignment_type not in (2,3,5,6)
951: )
952: AND not exists (select 1
953: from MSC_SR_ASSIGNMENTS msa2
954: where msa2.SR_Assignment_ID = mssa.SR_Assignment_ID
955: AND msa2.SR_Assignment_Instance_ID = mssa.SR_Assignment_Instance_ID
956: AND msa2.collected_flag = MSC_UTIL.SYS_YES);
957:

Line 966: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_ASSIGNMENTS');

962:
963: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
964: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
965: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
966: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_ASSIGNMENTS');
967: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
968:
969: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
970: RAISE;

Line 979: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_ASSIGNMENTS');

975:
976: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
977: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
978: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
979: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_ASSIGNMENTS');
980: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
981:
982: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
983: END IF;

Line 990: DELETE MSC_SR_ASSIGNMENTS

986:
987:
988: COMMIT;
989:
990: DELETE MSC_SR_ASSIGNMENTS
991: WHERE DELETED_FLAG= MSC_UTIL.SYS_YES
992: AND SR_ASSIGNMENT_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
993: AND COLLECTED_FLAG= MSC_UTIL.SYS_YES;
994:

Line 999: msc_analyse_tables_pk.analyse_table( 'MSC_SR_ASSIGNMENTS');

995: COMMIT;
996:
997: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
998:
999: msc_analyse_tables_pk.analyse_table( 'MSC_SR_ASSIGNMENTS');
1000:
1001: END IF;
1002:
1003: --/* it's removed due to bug 1219661