DBA Data[Home] [Help]

APPS.MSC_CL_BOM_ODS_LOAD dependencies on MSC_BILL_OF_RESOURCES

Line 923: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BILL_OF_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1);

919: BEGIN
920:
921: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
922:
923: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BILL_OF_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1);
924: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BOR_REQUIREMENTS', MSC_CL_COLLECTION.v_instance_id, -1);
925:
926: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
927: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BILL_OF_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1);

Line 927: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BILL_OF_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1);

923: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BILL_OF_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1);
924: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BOR_REQUIREMENTS', MSC_CL_COLLECTION.v_instance_id, -1);
925:
926: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
927: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BILL_OF_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1);
928: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BOR_REQUIREMENTS', MSC_CL_COLLECTION.v_instance_id, -1);
929: ELSE
930: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
931: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BILL_OF_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);

Line 931: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BILL_OF_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);

927: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BILL_OF_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1);
928: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BOR_REQUIREMENTS', MSC_CL_COLLECTION.v_instance_id, -1);
929: ELSE
930: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
931: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BILL_OF_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
932: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BOR_REQUIREMENTS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
933: END IF;
934:
935: END IF; -- MSC_CL_COLLECTION.v_is_complete_refresh

Line 945: UPDATE MSC_BILL_OF_RESOURCES

941: BEGIN
942:
943: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
944:
945: UPDATE MSC_BILL_OF_RESOURCES
946: SET
947: DESCRIPTION= c_rec.DESCRIPTION,
948: DISABLE_DATE= c_rec.DISABLE_DATE,
949: ROLLUP_START_DATE= c_rec.ROLLUP_START_DATE,

Line 964: INSERT INTO MSC_BILL_OF_RESOURCES

960:
961:
962: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) OR SQL%NOTFOUND THEN
963:
964: INSERT INTO MSC_BILL_OF_RESOURCES
965: ( PLAN_ID,
966: BILL_OF_RESOURCES,
967: ORGANIZATION_ID,
968: DESCRIPTION,

Line 1010: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BILL_OF_RESOURCES');

1006:
1007: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1008: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1009: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOR');
1010: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BILL_OF_RESOURCES');
1011: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1012:
1013: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1014: RAISE;

Line 1022: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BILL_OF_RESOURCES');

1018:
1019: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1020: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1021: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOR');
1022: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BILL_OF_RESOURCES');
1023: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1024:
1025: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1026: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');