eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_CL_SUPPLY_ODS_LOAD dependencies on MSC_CL_COLLECTION

Line 3: -- G_JOB_DONE NUMBER := MSC_CL_COLLECTION.G_JOB_DONE;

1: PACKAGE BODY MSC_CL_SUPPLY_ODS_LOAD AS -- body
2: /*$Header: MSCLSUPB.pls 120.14 2008/03/13 11:11:18 sbyerram noship $*/
3: -- G_JOB_DONE NUMBER := MSC_CL_COLLECTION.G_JOB_DONE;
4: -- G_JOB_NOT_DONE NUMBER := MSC_CL_COLLECTION.G_JOB_NOT_DONE;
5: -- G_JOB_ERROR NUMBER := MSC_CL_COLLECTION.G_JOB_ERROR;
6: -- G_MRP_PO_ACK NUMBER := MSC_CL_COLLECTION.G_MRP_PO_ACK;
7: -- SYS_YES Number:= MSC_CL_COLLECTION.SYS_YES ;

Line 4: -- G_JOB_NOT_DONE NUMBER := MSC_CL_COLLECTION.G_JOB_NOT_DONE;

1: PACKAGE BODY MSC_CL_SUPPLY_ODS_LOAD AS -- body
2: /*$Header: MSCLSUPB.pls 120.14 2008/03/13 11:11:18 sbyerram noship $*/
3: -- G_JOB_DONE NUMBER := MSC_CL_COLLECTION.G_JOB_DONE;
4: -- G_JOB_NOT_DONE NUMBER := MSC_CL_COLLECTION.G_JOB_NOT_DONE;
5: -- G_JOB_ERROR NUMBER := MSC_CL_COLLECTION.G_JOB_ERROR;
6: -- G_MRP_PO_ACK NUMBER := MSC_CL_COLLECTION.G_MRP_PO_ACK;
7: -- SYS_YES Number:= MSC_CL_COLLECTION.SYS_YES ;
8: -- SYS_NO Number:= MSC_CL_COLLECTION.SYS_NO ;

Line 5: -- G_JOB_ERROR NUMBER := MSC_CL_COLLECTION.G_JOB_ERROR;

1: PACKAGE BODY MSC_CL_SUPPLY_ODS_LOAD AS -- body
2: /*$Header: MSCLSUPB.pls 120.14 2008/03/13 11:11:18 sbyerram noship $*/
3: -- G_JOB_DONE NUMBER := MSC_CL_COLLECTION.G_JOB_DONE;
4: -- G_JOB_NOT_DONE NUMBER := MSC_CL_COLLECTION.G_JOB_NOT_DONE;
5: -- G_JOB_ERROR NUMBER := MSC_CL_COLLECTION.G_JOB_ERROR;
6: -- G_MRP_PO_ACK NUMBER := MSC_CL_COLLECTION.G_MRP_PO_ACK;
7: -- SYS_YES Number:= MSC_CL_COLLECTION.SYS_YES ;
8: -- SYS_NO Number:= MSC_CL_COLLECTION.SYS_NO ;
9: -- PROMISED_DATE_PREF NUMBER := MSC_CL_COLLECTION.PROMISED_DATE_PREF;

Line 6: -- G_MRP_PO_ACK NUMBER := MSC_CL_COLLECTION.G_MRP_PO_ACK;

2: /*$Header: MSCLSUPB.pls 120.14 2008/03/13 11:11:18 sbyerram noship $*/
3: -- G_JOB_DONE NUMBER := MSC_CL_COLLECTION.G_JOB_DONE;
4: -- G_JOB_NOT_DONE NUMBER := MSC_CL_COLLECTION.G_JOB_NOT_DONE;
5: -- G_JOB_ERROR NUMBER := MSC_CL_COLLECTION.G_JOB_ERROR;
6: -- G_MRP_PO_ACK NUMBER := MSC_CL_COLLECTION.G_MRP_PO_ACK;
7: -- SYS_YES Number:= MSC_CL_COLLECTION.SYS_YES ;
8: -- SYS_NO Number:= MSC_CL_COLLECTION.SYS_NO ;
9: -- PROMISED_DATE_PREF NUMBER := MSC_CL_COLLECTION.PROMISED_DATE_PREF;
10: -- NEED_BY_DATE_PREF NUMBER := MSC_CL_COLLECTION.PROMISED_DATE_PREF;

Line 7: -- SYS_YES Number:= MSC_CL_COLLECTION.SYS_YES ;

3: -- G_JOB_DONE NUMBER := MSC_CL_COLLECTION.G_JOB_DONE;
4: -- G_JOB_NOT_DONE NUMBER := MSC_CL_COLLECTION.G_JOB_NOT_DONE;
5: -- G_JOB_ERROR NUMBER := MSC_CL_COLLECTION.G_JOB_ERROR;
6: -- G_MRP_PO_ACK NUMBER := MSC_CL_COLLECTION.G_MRP_PO_ACK;
7: -- SYS_YES Number:= MSC_CL_COLLECTION.SYS_YES ;
8: -- SYS_NO Number:= MSC_CL_COLLECTION.SYS_NO ;
9: -- PROMISED_DATE_PREF NUMBER := MSC_CL_COLLECTION.PROMISED_DATE_PREF;
10: -- NEED_BY_DATE_PREF NUMBER := MSC_CL_COLLECTION.PROMISED_DATE_PREF;
11: -- G_ALL_ORGANIZATIONS VARCHAR2(6):= MSC_CL_COLLECTION.G_ALL_ORGANIZATIONS;

Line 8: -- SYS_NO Number:= MSC_CL_COLLECTION.SYS_NO ;

4: -- G_JOB_NOT_DONE NUMBER := MSC_CL_COLLECTION.G_JOB_NOT_DONE;
5: -- G_JOB_ERROR NUMBER := MSC_CL_COLLECTION.G_JOB_ERROR;
6: -- G_MRP_PO_ACK NUMBER := MSC_CL_COLLECTION.G_MRP_PO_ACK;
7: -- SYS_YES Number:= MSC_CL_COLLECTION.SYS_YES ;
8: -- SYS_NO Number:= MSC_CL_COLLECTION.SYS_NO ;
9: -- PROMISED_DATE_PREF NUMBER := MSC_CL_COLLECTION.PROMISED_DATE_PREF;
10: -- NEED_BY_DATE_PREF NUMBER := MSC_CL_COLLECTION.PROMISED_DATE_PREF;
11: -- G_ALL_ORGANIZATIONS VARCHAR2(6):= MSC_CL_COLLECTION.G_ALL_ORGANIZATIONS;
12: -- SYS_INCR Number:=MSC_CL_COLLECTION.SYS_INCR;

Line 9: -- PROMISED_DATE_PREF NUMBER := MSC_CL_COLLECTION.PROMISED_DATE_PREF;

5: -- G_JOB_ERROR NUMBER := MSC_CL_COLLECTION.G_JOB_ERROR;
6: -- G_MRP_PO_ACK NUMBER := MSC_CL_COLLECTION.G_MRP_PO_ACK;
7: -- SYS_YES Number:= MSC_CL_COLLECTION.SYS_YES ;
8: -- SYS_NO Number:= MSC_CL_COLLECTION.SYS_NO ;
9: -- PROMISED_DATE_PREF NUMBER := MSC_CL_COLLECTION.PROMISED_DATE_PREF;
10: -- NEED_BY_DATE_PREF NUMBER := MSC_CL_COLLECTION.PROMISED_DATE_PREF;
11: -- G_ALL_ORGANIZATIONS VARCHAR2(6):= MSC_CL_COLLECTION.G_ALL_ORGANIZATIONS;
12: -- SYS_INCR Number:=MSC_CL_COLLECTION.SYS_INCR;
13: -- SYS_TGT Number:=MSC_CL_COLLECTION.SYS_TGT;

Line 10: -- NEED_BY_DATE_PREF NUMBER := MSC_CL_COLLECTION.PROMISED_DATE_PREF;

6: -- G_MRP_PO_ACK NUMBER := MSC_CL_COLLECTION.G_MRP_PO_ACK;
7: -- SYS_YES Number:= MSC_CL_COLLECTION.SYS_YES ;
8: -- SYS_NO Number:= MSC_CL_COLLECTION.SYS_NO ;
9: -- PROMISED_DATE_PREF NUMBER := MSC_CL_COLLECTION.PROMISED_DATE_PREF;
10: -- NEED_BY_DATE_PREF NUMBER := MSC_CL_COLLECTION.PROMISED_DATE_PREF;
11: -- G_ALL_ORGANIZATIONS VARCHAR2(6):= MSC_CL_COLLECTION.G_ALL_ORGANIZATIONS;
12: -- SYS_INCR Number:=MSC_CL_COLLECTION.SYS_INCR;
13: -- SYS_TGT Number:=MSC_CL_COLLECTION.SYS_TGT;
14: -- NULL_VALUE NUMBER:= MSC_UTIL.NULL_VALUE;

Line 11: -- G_ALL_ORGANIZATIONS VARCHAR2(6):= MSC_CL_COLLECTION.G_ALL_ORGANIZATIONS;

7: -- SYS_YES Number:= MSC_CL_COLLECTION.SYS_YES ;
8: -- SYS_NO Number:= MSC_CL_COLLECTION.SYS_NO ;
9: -- PROMISED_DATE_PREF NUMBER := MSC_CL_COLLECTION.PROMISED_DATE_PREF;
10: -- NEED_BY_DATE_PREF NUMBER := MSC_CL_COLLECTION.PROMISED_DATE_PREF;
11: -- G_ALL_ORGANIZATIONS VARCHAR2(6):= MSC_CL_COLLECTION.G_ALL_ORGANIZATIONS;
12: -- SYS_INCR Number:=MSC_CL_COLLECTION.SYS_INCR;
13: -- SYS_TGT Number:=MSC_CL_COLLECTION.SYS_TGT;
14: -- NULL_VALUE NUMBER:= MSC_UTIL.NULL_VALUE;
15: -- NULL_CHAR VARCHAR2(6):=MSC_UTIL.NULL_CHAR;

Line 12: -- SYS_INCR Number:=MSC_CL_COLLECTION.SYS_INCR;

8: -- SYS_NO Number:= MSC_CL_COLLECTION.SYS_NO ;
9: -- PROMISED_DATE_PREF NUMBER := MSC_CL_COLLECTION.PROMISED_DATE_PREF;
10: -- NEED_BY_DATE_PREF NUMBER := MSC_CL_COLLECTION.PROMISED_DATE_PREF;
11: -- G_ALL_ORGANIZATIONS VARCHAR2(6):= MSC_CL_COLLECTION.G_ALL_ORGANIZATIONS;
12: -- SYS_INCR Number:=MSC_CL_COLLECTION.SYS_INCR;
13: -- SYS_TGT Number:=MSC_CL_COLLECTION.SYS_TGT;
14: -- NULL_VALUE NUMBER:= MSC_UTIL.NULL_VALUE;
15: -- NULL_CHAR VARCHAR2(6):=MSC_UTIL.NULL_CHAR;
16: -- G_CONF_APS_SCE NUMBER :=MSC_CL_COLLECTION.G_CONF_APS_SCE;

Line 13: -- SYS_TGT Number:=MSC_CL_COLLECTION.SYS_TGT;

9: -- PROMISED_DATE_PREF NUMBER := MSC_CL_COLLECTION.PROMISED_DATE_PREF;
10: -- NEED_BY_DATE_PREF NUMBER := MSC_CL_COLLECTION.PROMISED_DATE_PREF;
11: -- G_ALL_ORGANIZATIONS VARCHAR2(6):= MSC_CL_COLLECTION.G_ALL_ORGANIZATIONS;
12: -- SYS_INCR Number:=MSC_CL_COLLECTION.SYS_INCR;
13: -- SYS_TGT Number:=MSC_CL_COLLECTION.SYS_TGT;
14: -- NULL_VALUE NUMBER:= MSC_UTIL.NULL_VALUE;
15: -- NULL_CHAR VARCHAR2(6):=MSC_UTIL.NULL_CHAR;
16: -- G_CONF_APS_SCE NUMBER :=MSC_CL_COLLECTION.G_CONF_APS_SCE;
17: -- G_CONF_SCE NUMBER :=MSC_CL_COLLECTION.G_CONF_SCE;

Line 16: -- G_CONF_APS_SCE NUMBER :=MSC_CL_COLLECTION.G_CONF_APS_SCE;

12: -- SYS_INCR Number:=MSC_CL_COLLECTION.SYS_INCR;
13: -- SYS_TGT Number:=MSC_CL_COLLECTION.SYS_TGT;
14: -- NULL_VALUE NUMBER:= MSC_UTIL.NULL_VALUE;
15: -- NULL_CHAR VARCHAR2(6):=MSC_UTIL.NULL_CHAR;
16: -- G_CONF_APS_SCE NUMBER :=MSC_CL_COLLECTION.G_CONF_APS_SCE;
17: -- G_CONF_SCE NUMBER :=MSC_CL_COLLECTION.G_CONF_SCE;
18:
19: FUNCTION IS_SUPPLIES_LOAD_DONE
20: RETURN boolean

Line 17: -- G_CONF_SCE NUMBER :=MSC_CL_COLLECTION.G_CONF_SCE;

13: -- SYS_TGT Number:=MSC_CL_COLLECTION.SYS_TGT;
14: -- NULL_VALUE NUMBER:= MSC_UTIL.NULL_VALUE;
15: -- NULL_CHAR VARCHAR2(6):=MSC_UTIL.NULL_CHAR;
16: -- G_CONF_APS_SCE NUMBER :=MSC_CL_COLLECTION.G_CONF_APS_SCE;
17: -- G_CONF_SCE NUMBER :=MSC_CL_COLLECTION.G_CONF_SCE;
18:
19: FUNCTION IS_SUPPLIES_LOAD_DONE
20: RETURN boolean
21: IS

Line 31: select nvl(SUPPLIES_LOAD_FLAG,MSC_CL_COLLECTION.G_JOB_NOT_DONE)

27: so that other procedures (Demand-WIP Demand - Sales orders - Resource Reqmnts) can start loading */
28:
29: LOOP
30:
31: select nvl(SUPPLIES_LOAD_FLAG,MSC_CL_COLLECTION.G_JOB_NOT_DONE)
32: into lv_is_job_done
33: from msc_apps_instances
34: where instance_id = MSC_CL_COLLECTION.v_instance_id;
35:

Line 34: where instance_id = MSC_CL_COLLECTION.v_instance_id;

30:
31: select nvl(SUPPLIES_LOAD_FLAG,MSC_CL_COLLECTION.G_JOB_NOT_DONE)
32: into lv_is_job_done
33: from msc_apps_instances
34: where instance_id = MSC_CL_COLLECTION.v_instance_id;
35:
36: select (SYSDATE- MSC_CL_COLLECTION.START_TIME) into lv_process_time from dual;
37:
38: IF lv_process_time > MSC_CL_COLLECTION.p_TIMEOUT/1440.0 THEN

Line 36: select (SYSDATE- MSC_CL_COLLECTION.START_TIME) into lv_process_time from dual;

32: into lv_is_job_done
33: from msc_apps_instances
34: where instance_id = MSC_CL_COLLECTION.v_instance_id;
35:
36: select (SYSDATE- MSC_CL_COLLECTION.START_TIME) into lv_process_time from dual;
37:
38: IF lv_process_time > MSC_CL_COLLECTION.p_TIMEOUT/1440.0 THEN
39: lv_is_job_done := MSC_CL_COLLECTION.G_JOB_ERROR;
40: END IF;

Line 38: IF lv_process_time > MSC_CL_COLLECTION.p_TIMEOUT/1440.0 THEN

34: where instance_id = MSC_CL_COLLECTION.v_instance_id;
35:
36: select (SYSDATE- MSC_CL_COLLECTION.START_TIME) into lv_process_time from dual;
37:
38: IF lv_process_time > MSC_CL_COLLECTION.p_TIMEOUT/1440.0 THEN
39: lv_is_job_done := MSC_CL_COLLECTION.G_JOB_ERROR;
40: END IF;
41:
42: EXIT WHEN (lv_is_job_done = MSC_CL_COLLECTION.G_JOB_DONE) OR (lv_is_job_done= MSC_CL_COLLECTION.G_JOB_ERROR);

Line 39: lv_is_job_done := MSC_CL_COLLECTION.G_JOB_ERROR;

35:
36: select (SYSDATE- MSC_CL_COLLECTION.START_TIME) into lv_process_time from dual;
37:
38: IF lv_process_time > MSC_CL_COLLECTION.p_TIMEOUT/1440.0 THEN
39: lv_is_job_done := MSC_CL_COLLECTION.G_JOB_ERROR;
40: END IF;
41:
42: EXIT WHEN (lv_is_job_done = MSC_CL_COLLECTION.G_JOB_DONE) OR (lv_is_job_done= MSC_CL_COLLECTION.G_JOB_ERROR);
43: END LOOP;

Line 42: EXIT WHEN (lv_is_job_done = MSC_CL_COLLECTION.G_JOB_DONE) OR (lv_is_job_done= MSC_CL_COLLECTION.G_JOB_ERROR);

38: IF lv_process_time > MSC_CL_COLLECTION.p_TIMEOUT/1440.0 THEN
39: lv_is_job_done := MSC_CL_COLLECTION.G_JOB_ERROR;
40: END IF;
41:
42: EXIT WHEN (lv_is_job_done = MSC_CL_COLLECTION.G_JOB_DONE) OR (lv_is_job_done= MSC_CL_COLLECTION.G_JOB_ERROR);
43: END LOOP;
44:
45: IF (lv_is_job_done = MSC_CL_COLLECTION.G_JOB_DONE) THEN
46: RETURN TRUE;

Line 45: IF (lv_is_job_done = MSC_CL_COLLECTION.G_JOB_DONE) THEN

41:
42: EXIT WHEN (lv_is_job_done = MSC_CL_COLLECTION.G_JOB_DONE) OR (lv_is_job_done= MSC_CL_COLLECTION.G_JOB_ERROR);
43: END LOOP;
44:
45: IF (lv_is_job_done = MSC_CL_COLLECTION.G_JOB_DONE) THEN
46: RETURN TRUE;
47: ELSIF (lv_is_job_done = MSC_CL_COLLECTION.G_JOB_ERROR) THEN
48: RETURN FALSE;
49: END IF;

Line 47: ELSIF (lv_is_job_done = MSC_CL_COLLECTION.G_JOB_ERROR) THEN

43: END LOOP;
44:
45: IF (lv_is_job_done = MSC_CL_COLLECTION.G_JOB_DONE) THEN
46: RETURN TRUE;
47: ELSIF (lv_is_job_done = MSC_CL_COLLECTION.G_JOB_ERROR) THEN
48: RETURN FALSE;
49: END IF;
50:
51: RETURN TRUE;

Line 70: lv_retval := FND_INSTALLATION.GET_APP_INFO ( 'FND', lv_dummy1, lv_dummy2, MSC_CL_COLLECTION.v_applsys_schema);

66: lv_dummy2 varchar2(32);
67:
68: BEGIN
69:
70: lv_retval := FND_INSTALLATION.GET_APP_INFO ( 'FND', lv_dummy1, lv_dummy2, MSC_CL_COLLECTION.v_applsys_schema);
71:
72: ad_ddl.do_ddl( applsys_schema => MSC_CL_COLLECTION.v_applsys_schema,
73: application_short_name => 'MSC',
74: statement_type => AD_DDL.CREATE_INDEX,

Line 72: ad_ddl.do_ddl( applsys_schema => MSC_CL_COLLECTION.v_applsys_schema,

68: BEGIN
69:
70: lv_retval := FND_INSTALLATION.GET_APP_INFO ( 'FND', lv_dummy1, lv_dummy2, MSC_CL_COLLECTION.v_applsys_schema);
71:
72: ad_ddl.do_ddl( applsys_schema => MSC_CL_COLLECTION.v_applsys_schema,
73: application_short_name => 'MSC',
74: statement_type => AD_DDL.CREATE_INDEX,
75: statement =>
76: 'create index supplies_nx_'||MSC_CL_COLLECTION.v_instance_code

Line 76: 'create index supplies_nx_'||MSC_CL_COLLECTION.v_instance_code

72: ad_ddl.do_ddl( applsys_schema => MSC_CL_COLLECTION.v_applsys_schema,
73: application_short_name => 'MSC',
74: statement_type => AD_DDL.CREATE_INDEX,
75: statement =>
76: 'create index supplies_nx_'||MSC_CL_COLLECTION.v_instance_code
77: ||' on '||'supplies_'||MSC_CL_COLLECTION.v_instance_code
78: ||'(disposition_id, order_type) '
79: ||' PARALLEL ' || MSC_CL_COLLECTION.G_DEG_PARALLEL
80: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',

Line 77: ||' on '||'supplies_'||MSC_CL_COLLECTION.v_instance_code

73: application_short_name => 'MSC',
74: statement_type => AD_DDL.CREATE_INDEX,
75: statement =>
76: 'create index supplies_nx_'||MSC_CL_COLLECTION.v_instance_code
77: ||' on '||'supplies_'||MSC_CL_COLLECTION.v_instance_code
78: ||'(disposition_id, order_type) '
79: ||' PARALLEL ' || MSC_CL_COLLECTION.G_DEG_PARALLEL
80: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
81: object_name => 'supplies_nx_'||MSC_CL_COLLECTION.v_instance_code);

Line 79: ||' PARALLEL ' || MSC_CL_COLLECTION.G_DEG_PARALLEL

75: statement =>
76: 'create index supplies_nx_'||MSC_CL_COLLECTION.v_instance_code
77: ||' on '||'supplies_'||MSC_CL_COLLECTION.v_instance_code
78: ||'(disposition_id, order_type) '
79: ||' PARALLEL ' || MSC_CL_COLLECTION.G_DEG_PARALLEL
80: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
81: object_name => 'supplies_nx_'||MSC_CL_COLLECTION.v_instance_code);
82:
83: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' Index SUPPLIES_NX_'||MSC_CL_COLLECTION.v_instance_code||' created.');

Line 81: object_name => 'supplies_nx_'||MSC_CL_COLLECTION.v_instance_code);

77: ||' on '||'supplies_'||MSC_CL_COLLECTION.v_instance_code
78: ||'(disposition_id, order_type) '
79: ||' PARALLEL ' || MSC_CL_COLLECTION.G_DEG_PARALLEL
80: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
81: object_name => 'supplies_nx_'||MSC_CL_COLLECTION.v_instance_code);
82:
83: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' Index SUPPLIES_NX_'||MSC_CL_COLLECTION.v_instance_code||' created.');
84:
85: ad_ddl.do_ddl( applsys_schema => MSC_CL_COLLECTION.v_applsys_schema,

Line 83: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' Index SUPPLIES_NX_'||MSC_CL_COLLECTION.v_instance_code||' created.');

79: ||' PARALLEL ' || MSC_CL_COLLECTION.G_DEG_PARALLEL
80: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
81: object_name => 'supplies_nx_'||MSC_CL_COLLECTION.v_instance_code);
82:
83: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' Index SUPPLIES_NX_'||MSC_CL_COLLECTION.v_instance_code||' created.');
84:
85: ad_ddl.do_ddl( applsys_schema => MSC_CL_COLLECTION.v_applsys_schema,
86: application_short_name => 'MSC',
87: statement_type => AD_DDL.CREATE_INDEX,

Line 85: ad_ddl.do_ddl( applsys_schema => MSC_CL_COLLECTION.v_applsys_schema,

81: object_name => 'supplies_nx_'||MSC_CL_COLLECTION.v_instance_code);
82:
83: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' Index SUPPLIES_NX_'||MSC_CL_COLLECTION.v_instance_code||' created.');
84:
85: ad_ddl.do_ddl( applsys_schema => MSC_CL_COLLECTION.v_applsys_schema,
86: application_short_name => 'MSC',
87: statement_type => AD_DDL.CREATE_INDEX,
88: statement =>
89: 'create index supplies_nx1_'||MSC_CL_COLLECTION.v_instance_code

Line 89: 'create index supplies_nx1_'||MSC_CL_COLLECTION.v_instance_code

85: ad_ddl.do_ddl( applsys_schema => MSC_CL_COLLECTION.v_applsys_schema,
86: application_short_name => 'MSC',
87: statement_type => AD_DDL.CREATE_INDEX,
88: statement =>
89: 'create index supplies_nx1_'||MSC_CL_COLLECTION.v_instance_code
90: ||' on '||'supplies_'||MSC_CL_COLLECTION.v_instance_code
91: ||'(plan_id, sr_instance_id, order_number, purch_line_num) '
92: ||' PARALLEL ' || MSC_CL_COLLECTION.G_DEG_PARALLEL
93: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',

Line 90: ||' on '||'supplies_'||MSC_CL_COLLECTION.v_instance_code

86: application_short_name => 'MSC',
87: statement_type => AD_DDL.CREATE_INDEX,
88: statement =>
89: 'create index supplies_nx1_'||MSC_CL_COLLECTION.v_instance_code
90: ||' on '||'supplies_'||MSC_CL_COLLECTION.v_instance_code
91: ||'(plan_id, sr_instance_id, order_number, purch_line_num) '
92: ||' PARALLEL ' || MSC_CL_COLLECTION.G_DEG_PARALLEL
93: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
94: object_name => 'supplies_nx1_'||MSC_CL_COLLECTION.v_instance_code);

Line 92: ||' PARALLEL ' || MSC_CL_COLLECTION.G_DEG_PARALLEL

88: statement =>
89: 'create index supplies_nx1_'||MSC_CL_COLLECTION.v_instance_code
90: ||' on '||'supplies_'||MSC_CL_COLLECTION.v_instance_code
91: ||'(plan_id, sr_instance_id, order_number, purch_line_num) '
92: ||' PARALLEL ' || MSC_CL_COLLECTION.G_DEG_PARALLEL
93: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
94: object_name => 'supplies_nx1_'||MSC_CL_COLLECTION.v_instance_code);
95:
96: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' Index SUPPLIES_NX1_'||MSC_CL_COLLECTION.v_instance_code||' created.');

Line 94: object_name => 'supplies_nx1_'||MSC_CL_COLLECTION.v_instance_code);

90: ||' on '||'supplies_'||MSC_CL_COLLECTION.v_instance_code
91: ||'(plan_id, sr_instance_id, order_number, purch_line_num) '
92: ||' PARALLEL ' || MSC_CL_COLLECTION.G_DEG_PARALLEL
93: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
94: object_name => 'supplies_nx1_'||MSC_CL_COLLECTION.v_instance_code);
95:
96: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' Index SUPPLIES_NX1_'||MSC_CL_COLLECTION.v_instance_code||' created.');
97:
98: ad_ddl.do_ddl( applsys_schema => MSC_CL_COLLECTION.v_applsys_schema,

Line 96: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' Index SUPPLIES_NX1_'||MSC_CL_COLLECTION.v_instance_code||' created.');

92: ||' PARALLEL ' || MSC_CL_COLLECTION.G_DEG_PARALLEL
93: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
94: object_name => 'supplies_nx1_'||MSC_CL_COLLECTION.v_instance_code);
95:
96: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' Index SUPPLIES_NX1_'||MSC_CL_COLLECTION.v_instance_code||' created.');
97:
98: ad_ddl.do_ddl( applsys_schema => MSC_CL_COLLECTION.v_applsys_schema,
99: application_short_name => 'MSC',
100: statement_type => AD_DDL.CREATE_INDEX,

Line 98: ad_ddl.do_ddl( applsys_schema => MSC_CL_COLLECTION.v_applsys_schema,

94: object_name => 'supplies_nx1_'||MSC_CL_COLLECTION.v_instance_code);
95:
96: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' Index SUPPLIES_NX1_'||MSC_CL_COLLECTION.v_instance_code||' created.');
97:
98: ad_ddl.do_ddl( applsys_schema => MSC_CL_COLLECTION.v_applsys_schema,
99: application_short_name => 'MSC',
100: statement_type => AD_DDL.CREATE_INDEX,
101: statement =>
102: 'create index supplies_nx2_'||MSC_CL_COLLECTION.v_instance_code

Line 102: 'create index supplies_nx2_'||MSC_CL_COLLECTION.v_instance_code

98: ad_ddl.do_ddl( applsys_schema => MSC_CL_COLLECTION.v_applsys_schema,
99: application_short_name => 'MSC',
100: statement_type => AD_DDL.CREATE_INDEX,
101: statement =>
102: 'create index supplies_nx2_'||MSC_CL_COLLECTION.v_instance_code
103: ||' on '||'supplies_'||MSC_CL_COLLECTION.v_instance_code
104: ||'(plan_id, sr_instance_id, disposition_id, po_line_id ) '
105: ||' PARALLEL ' || MSC_CL_COLLECTION.G_DEG_PARALLEL
106: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',

Line 103: ||' on '||'supplies_'||MSC_CL_COLLECTION.v_instance_code

99: application_short_name => 'MSC',
100: statement_type => AD_DDL.CREATE_INDEX,
101: statement =>
102: 'create index supplies_nx2_'||MSC_CL_COLLECTION.v_instance_code
103: ||' on '||'supplies_'||MSC_CL_COLLECTION.v_instance_code
104: ||'(plan_id, sr_instance_id, disposition_id, po_line_id ) '
105: ||' PARALLEL ' || MSC_CL_COLLECTION.G_DEG_PARALLEL
106: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
107: object_name => 'supplies_nx2_'||MSC_CL_COLLECTION.v_instance_code);

Line 105: ||' PARALLEL ' || MSC_CL_COLLECTION.G_DEG_PARALLEL

101: statement =>
102: 'create index supplies_nx2_'||MSC_CL_COLLECTION.v_instance_code
103: ||' on '||'supplies_'||MSC_CL_COLLECTION.v_instance_code
104: ||'(plan_id, sr_instance_id, disposition_id, po_line_id ) '
105: ||' PARALLEL ' || MSC_CL_COLLECTION.G_DEG_PARALLEL
106: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
107: object_name => 'supplies_nx2_'||MSC_CL_COLLECTION.v_instance_code);
108: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' Index SUPPLIES_NX2_'||MSC_CL_COLLECTION.v_instance_code||' created.');
109:

Line 107: object_name => 'supplies_nx2_'||MSC_CL_COLLECTION.v_instance_code);

103: ||' on '||'supplies_'||MSC_CL_COLLECTION.v_instance_code
104: ||'(plan_id, sr_instance_id, disposition_id, po_line_id ) '
105: ||' PARALLEL ' || MSC_CL_COLLECTION.G_DEG_PARALLEL
106: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
107: object_name => 'supplies_nx2_'||MSC_CL_COLLECTION.v_instance_code);
108: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' Index SUPPLIES_NX2_'||MSC_CL_COLLECTION.v_instance_code||' created.');
109:
110: RETURN TRUE;
111:

Line 108: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' Index SUPPLIES_NX2_'||MSC_CL_COLLECTION.v_instance_code||' created.');

104: ||'(plan_id, sr_instance_id, disposition_id, po_line_id ) '
105: ||' PARALLEL ' || MSC_CL_COLLECTION.G_DEG_PARALLEL
106: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
107: object_name => 'supplies_nx2_'||MSC_CL_COLLECTION.v_instance_code);
108: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' Index SUPPLIES_NX2_'||MSC_CL_COLLECTION.v_instance_code||' created.');
109:
110: RETURN TRUE;
111:
112: EXCEPTION

Line 116: set SUPPLIES_LOAD_FLAG = MSC_CL_COLLECTION.G_JOB_ERROR

112: EXCEPTION
113: WHEN OTHERS THEN
114: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
115: update msc_apps_instances
116: set SUPPLIES_LOAD_FLAG = MSC_CL_COLLECTION.G_JOB_ERROR
117: where instance_id = MSC_CL_COLLECTION.v_instance_id;
118: commit;
119: RETURN FALSE;
120: END create_supplies_tmp_ind;

Line 117: where instance_id = MSC_CL_COLLECTION.v_instance_id;

113: WHEN OTHERS THEN
114: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
115: update msc_apps_instances
116: set SUPPLIES_LOAD_FLAG = MSC_CL_COLLECTION.G_JOB_ERROR
117: where instance_id = MSC_CL_COLLECTION.v_instance_id;
118: commit;
119: RETURN FALSE;
120: END create_supplies_tmp_ind;
121:

Line 138: , MSC_CL_COLLECTION.v_applsys_schema);

134:
135: BEGIN
136:
137: lv_retval := FND_INSTALLATION.GET_APP_INFO('FND', lv_dummy1, lv_dummy2
138: , MSC_CL_COLLECTION.v_applsys_schema);
139:
140: lv_retval := FND_INSTALLATION.GET_APP_INFO ('MSC', lv_dummy1, lv_dummy2,lv_msc_schema);
141:
142: lv_temp_sql_stmt := ' SELECT 1 '

Line 148: lv_ind_name := 'SUPPLIES_NX_'||MSC_CL_COLLECTION.v_instance_code;

144: ||' where owner = :p_schema '
145: ||' and table_owner = :p_schema '
146: ||' and index_name = upper(:ind_name) ' ;
147:
148: lv_ind_name := 'SUPPLIES_NX_'||MSC_CL_COLLECTION.v_instance_code;
149:
150: EXECUTE IMMEDIATE lv_temp_sql_stmt
151: INTO lv_drop_index
152: USING lv_msc_schema,lv_msc_schema,lv_ind_name;

Line 157: ad_ddl.do_ddl( applsys_schema => MSC_CL_COLLECTION.v_applsys_schema,

153:
154: IF (lv_drop_index = 1) THEN
155:
156: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Dropping the index :'||lv_ind_name);
157: ad_ddl.do_ddl( applsys_schema => MSC_CL_COLLECTION.v_applsys_schema,
158: application_short_name => 'MSC',
159: statement_type => AD_DDL.DROP_INDEX,
160: statement =>
161: 'drop index supplies_nx_'||MSC_CL_COLLECTION.v_instance_code,

Line 161: 'drop index supplies_nx_'||MSC_CL_COLLECTION.v_instance_code,

157: ad_ddl.do_ddl( applsys_schema => MSC_CL_COLLECTION.v_applsys_schema,
158: application_short_name => 'MSC',
159: statement_type => AD_DDL.DROP_INDEX,
160: statement =>
161: 'drop index supplies_nx_'||MSC_CL_COLLECTION.v_instance_code,
162: object_name => 'supplies_nx_'||MSC_CL_COLLECTION.v_instance_code);
163: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Dropped the index :'||lv_ind_name);
164:
165: lv_drop_index := 2;

Line 162: object_name => 'supplies_nx_'||MSC_CL_COLLECTION.v_instance_code);

158: application_short_name => 'MSC',
159: statement_type => AD_DDL.DROP_INDEX,
160: statement =>
161: 'drop index supplies_nx_'||MSC_CL_COLLECTION.v_instance_code,
162: object_name => 'supplies_nx_'||MSC_CL_COLLECTION.v_instance_code);
163: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Dropped the index :'||lv_ind_name);
164:
165: lv_drop_index := 2;
166: END IF;

Line 168: lv_ind_name := 'SUPPLIES_NX1_'||MSC_CL_COLLECTION.v_instance_code;

164:
165: lv_drop_index := 2;
166: END IF;
167:
168: lv_ind_name := 'SUPPLIES_NX1_'||MSC_CL_COLLECTION.v_instance_code;
169:
170: EXECUTE IMMEDIATE lv_temp_sql_stmt
171: INTO lv_drop_index
172: USING lv_msc_schema,lv_msc_schema,lv_ind_name;

Line 176: ad_ddl.do_ddl( applsys_schema => MSC_CL_COLLECTION.v_applsys_schema,

172: USING lv_msc_schema,lv_msc_schema,lv_ind_name;
173:
174: IF (lv_drop_index = 1) THEN
175: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Dropping the index :'||lv_ind_name);
176: ad_ddl.do_ddl( applsys_schema => MSC_CL_COLLECTION.v_applsys_schema,
177: application_short_name => 'MSC',
178: statement_type => AD_DDL.DROP_INDEX,
179: statement =>
180: 'drop index supplies_nx1_'||MSC_CL_COLLECTION.v_instance_code,

Line 180: 'drop index supplies_nx1_'||MSC_CL_COLLECTION.v_instance_code,

176: ad_ddl.do_ddl( applsys_schema => MSC_CL_COLLECTION.v_applsys_schema,
177: application_short_name => 'MSC',
178: statement_type => AD_DDL.DROP_INDEX,
179: statement =>
180: 'drop index supplies_nx1_'||MSC_CL_COLLECTION.v_instance_code,
181: object_name => 'supplies_nx1_'||MSC_CL_COLLECTION.v_instance_code);
182:
183: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Dropped the index :'||lv_ind_name);
184: lv_drop_index :=2 ;

Line 181: object_name => 'supplies_nx1_'||MSC_CL_COLLECTION.v_instance_code);

177: application_short_name => 'MSC',
178: statement_type => AD_DDL.DROP_INDEX,
179: statement =>
180: 'drop index supplies_nx1_'||MSC_CL_COLLECTION.v_instance_code,
181: object_name => 'supplies_nx1_'||MSC_CL_COLLECTION.v_instance_code);
182:
183: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Dropped the index :'||lv_ind_name);
184: lv_drop_index :=2 ;
185: END IF;

Line 187: lv_ind_name := 'SUPPLIES_NX2_'||MSC_CL_COLLECTION.v_instance_code;

183: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Dropped the index :'||lv_ind_name);
184: lv_drop_index :=2 ;
185: END IF;
186:
187: lv_ind_name := 'SUPPLIES_NX2_'||MSC_CL_COLLECTION.v_instance_code;
188:
189: EXECUTE IMMEDIATE lv_temp_sql_stmt
190: INTO lv_drop_index
191: USING lv_msc_schema,lv_msc_schema,lv_ind_name;

Line 195: ad_ddl.do_ddl( applsys_schema => MSC_CL_COLLECTION.v_applsys_schema,

191: USING lv_msc_schema,lv_msc_schema,lv_ind_name;
192:
193: IF (lv_drop_index = 1) THEN
194: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Dropping the index :'||lv_ind_name);
195: ad_ddl.do_ddl( applsys_schema => MSC_CL_COLLECTION.v_applsys_schema,
196: application_short_name => 'MSC',
197: statement_type => AD_DDL.DROP_INDEX,
198: statement =>
199: 'drop index supplies_nx2_'||MSC_CL_COLLECTION.v_instance_code,

Line 199: 'drop index supplies_nx2_'||MSC_CL_COLLECTION.v_instance_code,

195: ad_ddl.do_ddl( applsys_schema => MSC_CL_COLLECTION.v_applsys_schema,
196: application_short_name => 'MSC',
197: statement_type => AD_DDL.DROP_INDEX,
198: statement =>
199: 'drop index supplies_nx2_'||MSC_CL_COLLECTION.v_instance_code,
200: object_name => 'supplies_nx2_'||MSC_CL_COLLECTION.v_instance_code);
201: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Dropped the index :'||lv_ind_name);
202: lv_drop_index := 2;
203: END IF;

Line 200: object_name => 'supplies_nx2_'||MSC_CL_COLLECTION.v_instance_code);

196: application_short_name => 'MSC',
197: statement_type => AD_DDL.DROP_INDEX,
198: statement =>
199: 'drop index supplies_nx2_'||MSC_CL_COLLECTION.v_instance_code,
200: object_name => 'supplies_nx2_'||MSC_CL_COLLECTION.v_instance_code);
201: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Dropped the index :'||lv_ind_name);
202: lv_drop_index := 2;
203: END IF;
204:

Line 336: MSC_CL_COLLECTION.PROMISED_DATE_PREF, nvl(x.PROMISED_DATE, x.NEED_BY_DATE),

332: x.NEW_SHIP_DATE,
333: /* CP-ACK starts */
334: -- bug 2773881 - Use either PROMISED_DATE or NEED_BY_DATE
335: nvl(decode(lv_po_dock_date_ref,
336: MSC_CL_COLLECTION.PROMISED_DATE_PREF, nvl(x.PROMISED_DATE, x.NEED_BY_DATE),
337: MSC_CL_COLLECTION.NEED_BY_DATE_PREF , nvl(x.NEED_BY_DATE, x.PROMISED_DATE)
338: --PROMISED_DATE_PREF, x.NEW_DOCK_DATE,
339: --MSC_CL_COLLECTION.NEED_BY_DATE_PREF , nvl(x.NEED_BY_DATE, x.NEW_DOCK_DATE)
340: ),new_dock_date) NEW_DOCK_DATE,

Line 337: MSC_CL_COLLECTION.NEED_BY_DATE_PREF , nvl(x.NEED_BY_DATE, x.PROMISED_DATE)

333: /* CP-ACK starts */
334: -- bug 2773881 - Use either PROMISED_DATE or NEED_BY_DATE
335: nvl(decode(lv_po_dock_date_ref,
336: MSC_CL_COLLECTION.PROMISED_DATE_PREF, nvl(x.PROMISED_DATE, x.NEED_BY_DATE),
337: MSC_CL_COLLECTION.NEED_BY_DATE_PREF , nvl(x.NEED_BY_DATE, x.PROMISED_DATE)
338: --PROMISED_DATE_PREF, x.NEW_DOCK_DATE,
339: --MSC_CL_COLLECTION.NEED_BY_DATE_PREF , nvl(x.NEED_BY_DATE, x.NEW_DOCK_DATE)
340: ),new_dock_date) NEW_DOCK_DATE,
341: /* CP-ACK ends */

Line 339: --MSC_CL_COLLECTION.NEED_BY_DATE_PREF , nvl(x.NEED_BY_DATE, x.NEW_DOCK_DATE)

335: nvl(decode(lv_po_dock_date_ref,
336: MSC_CL_COLLECTION.PROMISED_DATE_PREF, nvl(x.PROMISED_DATE, x.NEED_BY_DATE),
337: MSC_CL_COLLECTION.NEED_BY_DATE_PREF , nvl(x.NEED_BY_DATE, x.PROMISED_DATE)
338: --PROMISED_DATE_PREF, x.NEW_DOCK_DATE,
339: --MSC_CL_COLLECTION.NEED_BY_DATE_PREF , nvl(x.NEED_BY_DATE, x.NEW_DOCK_DATE)
340: ),new_dock_date) NEW_DOCK_DATE,
341: /* CP-ACK ends */
342: x.LINE_ID,
343: x.PROJECT_ID,

Line 348: REPLACE(REPLACE(x.ORDER_NUMBER,MSC_CL_COLLECTION.v_chr10),MSC_CL_COLLECTION.v_chr13) ORDER_NUMBER,

344: x.TASK_ID,
345: x.PLANNING_GROUP,
346: x.NUMBER1,
347: x.SOURCE_ITEM_ID,
348: REPLACE(REPLACE(x.ORDER_NUMBER,MSC_CL_COLLECTION.v_chr10),MSC_CL_COLLECTION.v_chr13) ORDER_NUMBER,
349: x.SCHEDULE_GROUP_ID,
350: x.BUILD_SEQUENCE,
351: REPLACE(REPLACE(x.WIP_ENTITY_NAME,MSC_CL_COLLECTION.v_chr10),MSC_CL_COLLECTION.v_chr13) WIP_ENTITY_NAME,
352: x.IMPLEMENT_PROCESSING_DAYS,

Line 351: REPLACE(REPLACE(x.WIP_ENTITY_NAME,MSC_CL_COLLECTION.v_chr10),MSC_CL_COLLECTION.v_chr13) WIP_ENTITY_NAME,

347: x.SOURCE_ITEM_ID,
348: REPLACE(REPLACE(x.ORDER_NUMBER,MSC_CL_COLLECTION.v_chr10),MSC_CL_COLLECTION.v_chr13) ORDER_NUMBER,
349: x.SCHEDULE_GROUP_ID,
350: x.BUILD_SEQUENCE,
351: REPLACE(REPLACE(x.WIP_ENTITY_NAME,MSC_CL_COLLECTION.v_chr10),MSC_CL_COLLECTION.v_chr13) WIP_ENTITY_NAME,
352: x.IMPLEMENT_PROCESSING_DAYS,
353: x.DELIVERY_PRICE,
354: x.LATE_SUPPLY_DATE,
355: x.LATE_SUPPLY_QTY,

Line 434: AND x.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id

430: AND tps1.PARTNER_TYPE(+)= 1
431: AND tps2.SR_TP_SITE_ID(+)= x.OWNING_PARTNER_SITE_ID
432: AND tps2.SR_INSTANCE_ID(+)= x.SR_INSTANCE_ID
433: AND tps2.PARTNER_TYPE(+)= 1
434: AND x.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
435: AND x.DELETED_FLAG= MSC_UTIL.SYS_NO
436: AND md.SR_INSTANCE_ID(+)= x.SR_INSTANCE_ID
437: AND md.DESIGNATOR(+)= x.SCHEDULE_DESIGNATOR
438: AND md.Organization_ID(+)= x.Organization_ID

Line 441: AND x.ORDER_TYPE NOT IN (MSC_CL_COLLECTION.G_MRP_PO_ACK)

437: AND md.DESIGNATOR(+)= x.SCHEDULE_DESIGNATOR
438: AND md.Organization_ID(+)= x.Organization_ID
439: AND md.Designator_Type(+)= 2 -- MPS
440: /* CP-ACK starts */
441: AND x.ORDER_TYPE NOT IN (MSC_CL_COLLECTION.G_MRP_PO_ACK)
442: /* CP-ACK ends */
443: order by x.Organization_ID;
444:
445:

Line 471: AND x.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id

467: MSC_ST_SUPPLIES x,
468: MSC_TP_SITE_ID_LID tps1,
469: MSC_TP_SITE_ID_LID tps2
470: WHERE x.DELETED_FLAG= MSC_UTIL.SYS_YES
471: AND x.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
472: AND t1.SR_INVENTORY_ITEM_ID(+)= x.INVENTORY_ITEM_ID
473: AND t1.SR_INSTANCE_ID(+)= x.SR_INSTANCE_ID
474: AND tps1.SR_TP_SITE_ID(+)= x.PLANNING_PARTNER_SITE_ID
475: AND tps1.SR_INSTANCE_ID(+)= x.SR_INSTANCE_ID

Line 489: WHERE mshr.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id

485: mshr.ORGANIZATION_ID,
486: mshr.ORDER_TYPE
487: FROM MSC_ST_SUPPLIES mshr,
488: MSC_ITEM_ID_LID t1
489: WHERE mshr.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
490: AND mshr.RO_STATUS_CODE= 'C'
491: AND mshr.ORDER_TYPE=75
492: AND t1.SR_INVENTORY_ITEM_ID(+)= mshr.inventory_item_id
493: AND t1.sr_instance_id(+)= MSC_CL_COLLECTION.v_instance_id ;

Line 493: AND t1.sr_instance_id(+)= MSC_CL_COLLECTION.v_instance_id ;

489: WHERE mshr.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
490: AND mshr.RO_STATUS_CODE= 'C'
491: AND mshr.ORDER_TYPE=75
492: AND t1.SR_INVENTORY_ITEM_ID(+)= mshr.inventory_item_id
493: AND t1.sr_instance_id(+)= MSC_CL_COLLECTION.v_instance_id ;
494:
495:
496: BEGIN
497:

Line 499: lv_po_dock_date_ref := nvl(fnd_profile.value('MSC_PO_DOCK_DATE_CALC_PREF'), MSC_CL_COLLECTION.PROMISED_DATE_PREF);

495:
496: BEGIN
497:
498: /* CP-ACK starts */
499: lv_po_dock_date_ref := nvl(fnd_profile.value('MSC_PO_DOCK_DATE_CALC_PREF'), MSC_CL_COLLECTION.PROMISED_DATE_PREF);
500: /* CP-ACk ends */
501:
502: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
503: lv_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;

Line 502: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN

498: /* CP-ACK starts */
499: lv_po_dock_date_ref := nvl(fnd_profile.value('MSC_PO_DOCK_DATE_CALC_PREF'), MSC_CL_COLLECTION.PROMISED_DATE_PREF);
500: /* CP-ACk ends */
501:
502: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
503: lv_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
504: ELSE
505: lv_tbl:= 'MSC_SUPPLIES';
506: END IF;

Line 503: lv_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;

499: lv_po_dock_date_ref := nvl(fnd_profile.value('MSC_PO_DOCK_DATE_CALC_PREF'), MSC_CL_COLLECTION.PROMISED_DATE_PREF);
500: /* CP-ACk ends */
501:
502: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
503: lv_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
504: ELSE
505: lv_tbl:= 'MSC_SUPPLIES';
506: END IF;
507:

Line 778: IF MSC_CL_COLLECTION.v_is_complete_refresh AND MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_NO THEN

774:
775:
776: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'load_supply');
777:
778: IF MSC_CL_COLLECTION.v_is_complete_refresh AND MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_NO THEN
779:
780: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SUPPLIES', MSC_CL_COLLECTION.v_instance_id, -1);
781:
782: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN

Line 780: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SUPPLIES', MSC_CL_COLLECTION.v_instance_id, -1);

776: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'load_supply');
777:
778: IF MSC_CL_COLLECTION.v_is_complete_refresh AND MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_NO THEN
779:
780: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SUPPLIES', MSC_CL_COLLECTION.v_instance_id, -1);
781:
782: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
783: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SUPPLIES', MSC_CL_COLLECTION.v_instance_id, -1);
784: ELSE

Line 782: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN

778: IF MSC_CL_COLLECTION.v_is_complete_refresh AND MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_NO THEN
779:
780: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SUPPLIES', MSC_CL_COLLECTION.v_instance_id, -1);
781:
782: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
783: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SUPPLIES', MSC_CL_COLLECTION.v_instance_id, -1);
784: ELSE
785: MSC_CL_COLLECTION.v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
786: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SUPPLIES', MSC_CL_COLLECTION.v_instance_id, -1,MSC_CL_COLLECTION.v_sub_str);

Line 783: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SUPPLIES', MSC_CL_COLLECTION.v_instance_id, -1);

779:
780: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SUPPLIES', MSC_CL_COLLECTION.v_instance_id, -1);
781:
782: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
783: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SUPPLIES', MSC_CL_COLLECTION.v_instance_id, -1);
784: ELSE
785: MSC_CL_COLLECTION.v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
786: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SUPPLIES', MSC_CL_COLLECTION.v_instance_id, -1,MSC_CL_COLLECTION.v_sub_str);
787: END IF;

Line 785: MSC_CL_COLLECTION.v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;

781:
782: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
783: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SUPPLIES', MSC_CL_COLLECTION.v_instance_id, -1);
784: ELSE
785: MSC_CL_COLLECTION.v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
786: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SUPPLIES', MSC_CL_COLLECTION.v_instance_id, -1,MSC_CL_COLLECTION.v_sub_str);
787: END IF;
788:
789: END IF;

Line 786: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SUPPLIES', MSC_CL_COLLECTION.v_instance_id, -1,MSC_CL_COLLECTION.v_sub_str);

782: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
783: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SUPPLIES', MSC_CL_COLLECTION.v_instance_id, -1);
784: ELSE
785: MSC_CL_COLLECTION.v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
786: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SUPPLIES', MSC_CL_COLLECTION.v_instance_id, -1,MSC_CL_COLLECTION.v_sub_str);
787: END IF;
788:
789: END IF;
790:

Line 794: IF (MSC_CL_COLLECTION.v_is_incremental_refresh or MSC_CL_COLLECTION.v_is_cont_refresh) THEN

790:
791: --================= DELETE ==============
792: --agmcont
793:
794: IF (MSC_CL_COLLECTION.v_is_incremental_refresh or MSC_CL_COLLECTION.v_is_cont_refresh) THEN
795:
796: /* These intransit shipment supplies isn't supported for incremental
797: refresh.
798: In order to keep the transaction_id, set the quantitiy to zero

Line 803: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,

799: for delete. */
800:
801: /*UPDATE MSC_SUPPLIES
802: SET NEW_ORDER_QUANTITY= 0.0,
803: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
804: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
805: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
806: WHERE PLAN_ID= -1
807: AND SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id

Line 804: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,

800:
801: /*UPDATE MSC_SUPPLIES
802: SET NEW_ORDER_QUANTITY= 0.0,
803: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
804: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
805: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
806: WHERE PLAN_ID= -1
807: AND SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
808: AND ORDER_TYPE= 11

Line 805: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user

801: /*UPDATE MSC_SUPPLIES
802: SET NEW_ORDER_QUANTITY= 0.0,
803: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
804: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
805: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
806: WHERE PLAN_ID= -1
807: AND SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
808: AND ORDER_TYPE= 11
809: AND SR_MTL_SUPPLY_ID= -1;*/

Line 807: AND SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id

803: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
804: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
805: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
806: WHERE PLAN_ID= -1
807: AND SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
808: AND ORDER_TYPE= 11
809: AND SR_MTL_SUPPLY_ID= -1;*/
810:
811: lv_sql_stmt1 := ' UPDATE MSC_SUPPLIES '

Line 823: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN

819: ||' AND SR_INSTANCE_ID= :v_instance_id '
820: ||' AND ORDER_TYPE= 11 ' --Intransit shipment
821: ||' AND SR_MTL_SUPPLY_ID= -1 ';
822:
823: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
824: EXECUTE IMMEDIATE lv_sql_stmt1 USING MSC_CL_COLLECTION.v_last_collection_id,
825: MSC_CL_COLLECTION.v_current_date,
826: MSC_CL_COLLECTION.v_current_user,
827: MSC_CL_COLLECTION.v_instance_id;

Line 824: EXECUTE IMMEDIATE lv_sql_stmt1 USING MSC_CL_COLLECTION.v_last_collection_id,

820: ||' AND ORDER_TYPE= 11 ' --Intransit shipment
821: ||' AND SR_MTL_SUPPLY_ID= -1 ';
822:
823: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
824: EXECUTE IMMEDIATE lv_sql_stmt1 USING MSC_CL_COLLECTION.v_last_collection_id,
825: MSC_CL_COLLECTION.v_current_date,
826: MSC_CL_COLLECTION.v_current_user,
827: MSC_CL_COLLECTION.v_instance_id;
828: ELSE

Line 825: MSC_CL_COLLECTION.v_current_date,

821: ||' AND SR_MTL_SUPPLY_ID= -1 ';
822:
823: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
824: EXECUTE IMMEDIATE lv_sql_stmt1 USING MSC_CL_COLLECTION.v_last_collection_id,
825: MSC_CL_COLLECTION.v_current_date,
826: MSC_CL_COLLECTION.v_current_user,
827: MSC_CL_COLLECTION.v_instance_id;
828: ELSE
829: lv_sql_stmt1:=lv_sql_stmt1||' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;

Line 826: MSC_CL_COLLECTION.v_current_user,

822:
823: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
824: EXECUTE IMMEDIATE lv_sql_stmt1 USING MSC_CL_COLLECTION.v_last_collection_id,
825: MSC_CL_COLLECTION.v_current_date,
826: MSC_CL_COLLECTION.v_current_user,
827: MSC_CL_COLLECTION.v_instance_id;
828: ELSE
829: lv_sql_stmt1:=lv_sql_stmt1||' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
830: EXECUTE IMMEDIATE lv_sql_stmt1 USING MSC_CL_COLLECTION.v_last_collection_id,

Line 827: MSC_CL_COLLECTION.v_instance_id;

823: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
824: EXECUTE IMMEDIATE lv_sql_stmt1 USING MSC_CL_COLLECTION.v_last_collection_id,
825: MSC_CL_COLLECTION.v_current_date,
826: MSC_CL_COLLECTION.v_current_user,
827: MSC_CL_COLLECTION.v_instance_id;
828: ELSE
829: lv_sql_stmt1:=lv_sql_stmt1||' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
830: EXECUTE IMMEDIATE lv_sql_stmt1 USING MSC_CL_COLLECTION.v_last_collection_id,
831: MSC_CL_COLLECTION.v_current_date,

Line 830: EXECUTE IMMEDIATE lv_sql_stmt1 USING MSC_CL_COLLECTION.v_last_collection_id,

826: MSC_CL_COLLECTION.v_current_user,
827: MSC_CL_COLLECTION.v_instance_id;
828: ELSE
829: lv_sql_stmt1:=lv_sql_stmt1||' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
830: EXECUTE IMMEDIATE lv_sql_stmt1 USING MSC_CL_COLLECTION.v_last_collection_id,
831: MSC_CL_COLLECTION.v_current_date,
832: MSC_CL_COLLECTION.v_current_user,
833: MSC_CL_COLLECTION.v_instance_id;
834:

Line 831: MSC_CL_COLLECTION.v_current_date,

827: MSC_CL_COLLECTION.v_instance_id;
828: ELSE
829: lv_sql_stmt1:=lv_sql_stmt1||' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
830: EXECUTE IMMEDIATE lv_sql_stmt1 USING MSC_CL_COLLECTION.v_last_collection_id,
831: MSC_CL_COLLECTION.v_current_date,
832: MSC_CL_COLLECTION.v_current_user,
833: MSC_CL_COLLECTION.v_instance_id;
834:
835: END IF;

Line 832: MSC_CL_COLLECTION.v_current_user,

828: ELSE
829: lv_sql_stmt1:=lv_sql_stmt1||' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
830: EXECUTE IMMEDIATE lv_sql_stmt1 USING MSC_CL_COLLECTION.v_last_collection_id,
831: MSC_CL_COLLECTION.v_current_date,
832: MSC_CL_COLLECTION.v_current_user,
833: MSC_CL_COLLECTION.v_instance_id;
834:
835: END IF;
836:

Line 833: MSC_CL_COLLECTION.v_instance_id;

829: lv_sql_stmt1:=lv_sql_stmt1||' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
830: EXECUTE IMMEDIATE lv_sql_stmt1 USING MSC_CL_COLLECTION.v_last_collection_id,
831: MSC_CL_COLLECTION.v_current_date,
832: MSC_CL_COLLECTION.v_current_user,
833: MSC_CL_COLLECTION.v_instance_id;
834:
835: END IF;
836:
837: COMMIT;

Line 843: IF (MSC_CL_COLLECTION.v_is_incremental_refresh and c_rec.ORDER_TYPE IN (1,2,8,11,12,73,74,87)) or

839: c_count:= 0;
840:
841: FOR c_rec IN c1_d LOOP
842: --1 =PO, 2 = PO REQ, 8 = PO receiving, 12= Intrasit Receipt
843: IF (MSC_CL_COLLECTION.v_is_incremental_refresh and c_rec.ORDER_TYPE IN (1,2,8,11,12,73,74,87)) or
844: (MSC_CL_COLLECTION.v_is_cont_refresh and (c_rec.ORDER_TYPE IN (1,2,8,11,12,73,74,87)) and
845: (MSC_CL_COLLECTION.v_coll_prec.po_sn_flag = MSC_UTIL.SYS_INCR)) THEN -- PO
846:
847: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'load_supply: upd PO-0');

Line 844: (MSC_CL_COLLECTION.v_is_cont_refresh and (c_rec.ORDER_TYPE IN (1,2,8,11,12,73,74,87)) and

840:
841: FOR c_rec IN c1_d LOOP
842: --1 =PO, 2 = PO REQ, 8 = PO receiving, 12= Intrasit Receipt
843: IF (MSC_CL_COLLECTION.v_is_incremental_refresh and c_rec.ORDER_TYPE IN (1,2,8,11,12,73,74,87)) or
844: (MSC_CL_COLLECTION.v_is_cont_refresh and (c_rec.ORDER_TYPE IN (1,2,8,11,12,73,74,87)) and
845: (MSC_CL_COLLECTION.v_coll_prec.po_sn_flag = MSC_UTIL.SYS_INCR)) THEN -- PO
846:
847: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'load_supply: upd PO-0');
848:

Line 845: (MSC_CL_COLLECTION.v_coll_prec.po_sn_flag = MSC_UTIL.SYS_INCR)) THEN -- PO

841: FOR c_rec IN c1_d LOOP
842: --1 =PO, 2 = PO REQ, 8 = PO receiving, 12= Intrasit Receipt
843: IF (MSC_CL_COLLECTION.v_is_incremental_refresh and c_rec.ORDER_TYPE IN (1,2,8,11,12,73,74,87)) or
844: (MSC_CL_COLLECTION.v_is_cont_refresh and (c_rec.ORDER_TYPE IN (1,2,8,11,12,73,74,87)) and
845: (MSC_CL_COLLECTION.v_coll_prec.po_sn_flag = MSC_UTIL.SYS_INCR)) THEN -- PO
846:
847: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'load_supply: upd PO-0');
848:
849:

Line 854: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,

850: UPDATE MSC_SUPPLIES ms
851: SET OLD_NEW_SCHEDULE_DATE = NEW_SCHEDULE_DATE,
852: OLD_NEW_ORDER_QUANTITY = NEW_ORDER_QUANTITY,
853: NEW_ORDER_QUANTITY= 0.0,
854: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
855: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
856: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
857: WHERE PLAN_ID= -1
858: AND SR_INSTANCE_ID= c_rec.SR_INSTANCE_ID

Line 855: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,

851: SET OLD_NEW_SCHEDULE_DATE = NEW_SCHEDULE_DATE,
852: OLD_NEW_ORDER_QUANTITY = NEW_ORDER_QUANTITY,
853: NEW_ORDER_QUANTITY= 0.0,
854: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
855: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
856: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
857: WHERE PLAN_ID= -1
858: AND SR_INSTANCE_ID= c_rec.SR_INSTANCE_ID
859: AND ORDER_TYPE IN (1,2,8,11,12,73,74,87)

Line 856: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user

852: OLD_NEW_ORDER_QUANTITY = NEW_ORDER_QUANTITY,
853: NEW_ORDER_QUANTITY= 0.0,
854: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
855: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
856: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
857: WHERE PLAN_ID= -1
858: AND SR_INSTANCE_ID= c_rec.SR_INSTANCE_ID
859: AND ORDER_TYPE IN (1,2,8,11,12,73,74,87)
860: AND SR_MTL_SUPPLY_ID= c_rec.SR_MTL_SUPPLY_ID;

Line 863: ELSIF (MSC_CL_COLLECTION.v_is_incremental_refresh and c_rec.ORDER_TYPE IN (3,7,27, 70,86)) or

859: AND ORDER_TYPE IN (1,2,8,11,12,73,74,87)
860: AND SR_MTL_SUPPLY_ID= c_rec.SR_MTL_SUPPLY_ID;
861:
862: /*3 Discret Job, 7 Non STandard Job, 27 Flow schedule, 70 Eam supply: ds change change,86 External Repair Order */
863: ELSIF (MSC_CL_COLLECTION.v_is_incremental_refresh and c_rec.ORDER_TYPE IN (3,7,27, 70,86)) or
864: (MSC_CL_COLLECTION.v_is_cont_refresh and (c_rec.ORDER_TYPE IN (3,7,27,70)) and
865: (MSC_CL_COLLECTION.v_coll_prec.wip_sn_flag = MSC_UTIL.SYS_INCR)) THEN -- WIP_JOB
866:
867: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'load_supply: upd WIP-0');

Line 864: (MSC_CL_COLLECTION.v_is_cont_refresh and (c_rec.ORDER_TYPE IN (3,7,27,70)) and

860: AND SR_MTL_SUPPLY_ID= c_rec.SR_MTL_SUPPLY_ID;
861:
862: /*3 Discret Job, 7 Non STandard Job, 27 Flow schedule, 70 Eam supply: ds change change,86 External Repair Order */
863: ELSIF (MSC_CL_COLLECTION.v_is_incremental_refresh and c_rec.ORDER_TYPE IN (3,7,27, 70,86)) or
864: (MSC_CL_COLLECTION.v_is_cont_refresh and (c_rec.ORDER_TYPE IN (3,7,27,70)) and
865: (MSC_CL_COLLECTION.v_coll_prec.wip_sn_flag = MSC_UTIL.SYS_INCR)) THEN -- WIP_JOB
866:
867: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'load_supply: upd WIP-0');
868: if c_rec.ORDER_TYPE = 70 then

Line 865: (MSC_CL_COLLECTION.v_coll_prec.wip_sn_flag = MSC_UTIL.SYS_INCR)) THEN -- WIP_JOB

861:
862: /*3 Discret Job, 7 Non STandard Job, 27 Flow schedule, 70 Eam supply: ds change change,86 External Repair Order */
863: ELSIF (MSC_CL_COLLECTION.v_is_incremental_refresh and c_rec.ORDER_TYPE IN (3,7,27, 70,86)) or
864: (MSC_CL_COLLECTION.v_is_cont_refresh and (c_rec.ORDER_TYPE IN (3,7,27,70)) and
865: (MSC_CL_COLLECTION.v_coll_prec.wip_sn_flag = MSC_UTIL.SYS_INCR)) THEN -- WIP_JOB
866:
867: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'load_supply: upd WIP-0');
868: if c_rec.ORDER_TYPE = 70 then
869: MSC_CL_COLLECTION.link_top_transaction_id_req := TRUE;

Line 869: MSC_CL_COLLECTION.link_top_transaction_id_req := TRUE;

865: (MSC_CL_COLLECTION.v_coll_prec.wip_sn_flag = MSC_UTIL.SYS_INCR)) THEN -- WIP_JOB
866:
867: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'load_supply: upd WIP-0');
868: if c_rec.ORDER_TYPE = 70 then
869: MSC_CL_COLLECTION.link_top_transaction_id_req := TRUE;
870: end if;
871:
872: UPDATE MSC_SUPPLIES ms
873: SET OLD_NEW_SCHEDULE_DATE = NEW_SCHEDULE_DATE,

Line 876: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,

872: UPDATE MSC_SUPPLIES ms
873: SET OLD_NEW_SCHEDULE_DATE = NEW_SCHEDULE_DATE,
874: OLD_NEW_ORDER_QUANTITY = NEW_ORDER_QUANTITY,
875: NEW_ORDER_QUANTITY= 0.0,
876: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
877: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
878: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
879: WHERE ms.PLAN_ID= -1
880: AND ms.SR_INSTANCE_ID= c_rec.SR_INSTANCE_ID

Line 877: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,

873: SET OLD_NEW_SCHEDULE_DATE = NEW_SCHEDULE_DATE,
874: OLD_NEW_ORDER_QUANTITY = NEW_ORDER_QUANTITY,
875: NEW_ORDER_QUANTITY= 0.0,
876: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
877: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
878: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
879: WHERE ms.PLAN_ID= -1
880: AND ms.SR_INSTANCE_ID= c_rec.SR_INSTANCE_ID
881: AND ms.ORDER_TYPE= c_rec.ORDER_TYPE

Line 878: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user

874: OLD_NEW_ORDER_QUANTITY = NEW_ORDER_QUANTITY,
875: NEW_ORDER_QUANTITY= 0.0,
876: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
877: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
878: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
879: WHERE ms.PLAN_ID= -1
880: AND ms.SR_INSTANCE_ID= c_rec.SR_INSTANCE_ID
881: AND ms.ORDER_TYPE= c_rec.ORDER_TYPE
882: AND ms.DISPOSITION_ID= c_rec.DISPOSITION_ID;

Line 886: ELSIF (MSC_CL_COLLECTION.v_is_incremental_refresh and c_rec.ORDER_TYPE IN (14,15)) or

882: AND ms.DISPOSITION_ID= c_rec.DISPOSITION_ID;
883:
884:
885: -- 14=discrete job co product, 15 non stanstard job co-product
886: ELSIF (MSC_CL_COLLECTION.v_is_incremental_refresh and c_rec.ORDER_TYPE IN (14,15)) or
887: (MSC_CL_COLLECTION.v_is_cont_refresh and (c_rec.ORDER_TYPE IN (14,15)) and
888: (MSC_CL_COLLECTION.v_coll_prec.wip_sn_flag = MSC_UTIL.SYS_INCR)) THEN -- DISCRETE JOB COMPONENT
889:
890: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'load_supply: upd WIP DSC JOB-0');

Line 887: (MSC_CL_COLLECTION.v_is_cont_refresh and (c_rec.ORDER_TYPE IN (14,15)) and

883:
884:
885: -- 14=discrete job co product, 15 non stanstard job co-product
886: ELSIF (MSC_CL_COLLECTION.v_is_incremental_refresh and c_rec.ORDER_TYPE IN (14,15)) or
887: (MSC_CL_COLLECTION.v_is_cont_refresh and (c_rec.ORDER_TYPE IN (14,15)) and
888: (MSC_CL_COLLECTION.v_coll_prec.wip_sn_flag = MSC_UTIL.SYS_INCR)) THEN -- DISCRETE JOB COMPONENT
889:
890: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'load_supply: upd WIP DSC JOB-0');
891:

Line 888: (MSC_CL_COLLECTION.v_coll_prec.wip_sn_flag = MSC_UTIL.SYS_INCR)) THEN -- DISCRETE JOB COMPONENT

884:
885: -- 14=discrete job co product, 15 non stanstard job co-product
886: ELSIF (MSC_CL_COLLECTION.v_is_incremental_refresh and c_rec.ORDER_TYPE IN (14,15)) or
887: (MSC_CL_COLLECTION.v_is_cont_refresh and (c_rec.ORDER_TYPE IN (14,15)) and
888: (MSC_CL_COLLECTION.v_coll_prec.wip_sn_flag = MSC_UTIL.SYS_INCR)) THEN -- DISCRETE JOB COMPONENT
889:
890: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'load_supply: upd WIP DSC JOB-0');
891:
892:

Line 897: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,

893: UPDATE MSC_SUPPLIES ms
894: SET OLD_NEW_SCHEDULE_DATE = NEW_SCHEDULE_DATE,
895: OLD_NEW_ORDER_QUANTITY = NEW_ORDER_QUANTITY,
896: NEW_ORDER_QUANTITY= 0.0,
897: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
898: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
899: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
900: WHERE PLAN_ID= -1
901: AND SR_INSTANCE_ID= c_rec.SR_INSTANCE_ID

Line 898: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,

894: SET OLD_NEW_SCHEDULE_DATE = NEW_SCHEDULE_DATE,
895: OLD_NEW_ORDER_QUANTITY = NEW_ORDER_QUANTITY,
896: NEW_ORDER_QUANTITY= 0.0,
897: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
898: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
899: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
900: WHERE PLAN_ID= -1
901: AND SR_INSTANCE_ID= c_rec.SR_INSTANCE_ID
902: AND ORDER_TYPE= c_rec.ORDER_TYPE

Line 899: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user

895: OLD_NEW_ORDER_QUANTITY = NEW_ORDER_QUANTITY,
896: NEW_ORDER_QUANTITY= 0.0,
897: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
898: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
899: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
900: WHERE PLAN_ID= -1
901: AND SR_INSTANCE_ID= c_rec.SR_INSTANCE_ID
902: AND ORDER_TYPE= c_rec.ORDER_TYPE
903: AND INVENTORY_ITEM_ID= NVL(c_rec.INVENTORY_ITEM_ID,INVENTORY_ITEM_ID)

Line 907: ELSIF (MSC_CL_COLLECTION.v_is_incremental_refresh and c_rec.ORDER_TYPE= 30) or

903: AND INVENTORY_ITEM_ID= NVL(c_rec.INVENTORY_ITEM_ID,INVENTORY_ITEM_ID)
904: AND DISPOSITION_ID= c_rec.DISPOSITION_ID
905: AND OPERATION_SEQ_NUM= NVL(c_rec.OPERATION_SEQ_NUM,OPERATION_SEQ_NUM);
906:
907: ELSIF (MSC_CL_COLLECTION.v_is_incremental_refresh and c_rec.ORDER_TYPE= 30) or
908: (MSC_CL_COLLECTION.v_is_cont_refresh and (c_rec.ORDER_TYPE = 30) and
909: (MSC_CL_COLLECTION.v_coll_prec.wip_sn_flag = MSC_UTIL.SYS_INCR)) THEN -- REPT ITEM
910:
911: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'load_supply: upd WIP REPT ITEM-0');

Line 908: (MSC_CL_COLLECTION.v_is_cont_refresh and (c_rec.ORDER_TYPE = 30) and

904: AND DISPOSITION_ID= c_rec.DISPOSITION_ID
905: AND OPERATION_SEQ_NUM= NVL(c_rec.OPERATION_SEQ_NUM,OPERATION_SEQ_NUM);
906:
907: ELSIF (MSC_CL_COLLECTION.v_is_incremental_refresh and c_rec.ORDER_TYPE= 30) or
908: (MSC_CL_COLLECTION.v_is_cont_refresh and (c_rec.ORDER_TYPE = 30) and
909: (MSC_CL_COLLECTION.v_coll_prec.wip_sn_flag = MSC_UTIL.SYS_INCR)) THEN -- REPT ITEM
910:
911: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'load_supply: upd WIP REPT ITEM-0');
912:

Line 909: (MSC_CL_COLLECTION.v_coll_prec.wip_sn_flag = MSC_UTIL.SYS_INCR)) THEN -- REPT ITEM

905: AND OPERATION_SEQ_NUM= NVL(c_rec.OPERATION_SEQ_NUM,OPERATION_SEQ_NUM);
906:
907: ELSIF (MSC_CL_COLLECTION.v_is_incremental_refresh and c_rec.ORDER_TYPE= 30) or
908: (MSC_CL_COLLECTION.v_is_cont_refresh and (c_rec.ORDER_TYPE = 30) and
909: (MSC_CL_COLLECTION.v_coll_prec.wip_sn_flag = MSC_UTIL.SYS_INCR)) THEN -- REPT ITEM
910:
911: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'load_supply: upd WIP REPT ITEM-0');
912:
913:

Line 922: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,

918: OLD_FIRST_UNIT_START_DATE= FIRST_UNIT_START_DATE,
919: OLD_LAST_UNIT_COMPLETION_DATE= LAST_UNIT_COMPLETION_DATE,
920: NEW_ORDER_QUANTITY= 0.0,
921: DAILY_RATE = 0.0,
922: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
923: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
924: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
925: WHERE PLAN_ID= -1
926: AND SR_INSTANCE_ID= c_rec.SR_INSTANCE_ID

Line 923: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,

919: OLD_LAST_UNIT_COMPLETION_DATE= LAST_UNIT_COMPLETION_DATE,
920: NEW_ORDER_QUANTITY= 0.0,
921: DAILY_RATE = 0.0,
922: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
923: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
924: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
925: WHERE PLAN_ID= -1
926: AND SR_INSTANCE_ID= c_rec.SR_INSTANCE_ID
927: AND ORDER_TYPE= c_rec.ORDER_TYPE

Line 924: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user

920: NEW_ORDER_QUANTITY= 0.0,
921: DAILY_RATE = 0.0,
922: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
923: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
924: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
925: WHERE PLAN_ID= -1
926: AND SR_INSTANCE_ID= c_rec.SR_INSTANCE_ID
927: AND ORDER_TYPE= c_rec.ORDER_TYPE
928: AND DISPOSITION_ID= c_rec.DISPOSITION_ID

Line 931: ELSIF (MSC_CL_COLLECTION.v_is_incremental_refresh and c_rec.ORDER_TYPE= 18) or

927: AND ORDER_TYPE= c_rec.ORDER_TYPE
928: AND DISPOSITION_ID= c_rec.DISPOSITION_ID
929: AND ORGANIZATION_ID = c_rec.ORGANIZATION_ID;
930:
931: ELSIF (MSC_CL_COLLECTION.v_is_incremental_refresh and c_rec.ORDER_TYPE= 18) or
932: (MSC_CL_COLLECTION.v_is_cont_refresh and (c_rec.ORDER_TYPE = 18) and
933: (MSC_CL_COLLECTION.v_coll_prec.oh_sn_flag = MSC_UTIL.SYS_INCR)) THEN -- ONHAND
934:
935: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'load_supply: upd OH-0');

Line 932: (MSC_CL_COLLECTION.v_is_cont_refresh and (c_rec.ORDER_TYPE = 18) and

928: AND DISPOSITION_ID= c_rec.DISPOSITION_ID
929: AND ORGANIZATION_ID = c_rec.ORGANIZATION_ID;
930:
931: ELSIF (MSC_CL_COLLECTION.v_is_incremental_refresh and c_rec.ORDER_TYPE= 18) or
932: (MSC_CL_COLLECTION.v_is_cont_refresh and (c_rec.ORDER_TYPE = 18) and
933: (MSC_CL_COLLECTION.v_coll_prec.oh_sn_flag = MSC_UTIL.SYS_INCR)) THEN -- ONHAND
934:
935: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'load_supply: upd OH-0');
936:

Line 933: (MSC_CL_COLLECTION.v_coll_prec.oh_sn_flag = MSC_UTIL.SYS_INCR)) THEN -- ONHAND

929: AND ORGANIZATION_ID = c_rec.ORGANIZATION_ID;
930:
931: ELSIF (MSC_CL_COLLECTION.v_is_incremental_refresh and c_rec.ORDER_TYPE= 18) or
932: (MSC_CL_COLLECTION.v_is_cont_refresh and (c_rec.ORDER_TYPE = 18) and
933: (MSC_CL_COLLECTION.v_coll_prec.oh_sn_flag = MSC_UTIL.SYS_INCR)) THEN -- ONHAND
934:
935: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'load_supply: upd OH-0');
936:
937:

Line 943: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,

939: --SET NEW_ORDER_QUANTITY= 0.0,
940: SET OLD_NEW_SCHEDULE_DATE = NEW_SCHEDULE_DATE,
941: OLD_NEW_ORDER_QUANTITY = NEW_ORDER_QUANTITY,
942: NEW_ORDER_QUANTITY= NEW_ORDER_QUANTITY-c_rec.NEW_ORDER_QUANTITY, /*Bug: 2791310 */
943: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
944: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
945: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
946: WHERE PLAN_ID= -1
947: AND SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id

Line 944: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,

940: SET OLD_NEW_SCHEDULE_DATE = NEW_SCHEDULE_DATE,
941: OLD_NEW_ORDER_QUANTITY = NEW_ORDER_QUANTITY,
942: NEW_ORDER_QUANTITY= NEW_ORDER_QUANTITY-c_rec.NEW_ORDER_QUANTITY, /*Bug: 2791310 */
943: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
944: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
945: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
946: WHERE PLAN_ID= -1
947: AND SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
948: AND ORDER_TYPE= 18

Line 945: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user

941: OLD_NEW_ORDER_QUANTITY = NEW_ORDER_QUANTITY,
942: NEW_ORDER_QUANTITY= NEW_ORDER_QUANTITY-c_rec.NEW_ORDER_QUANTITY, /*Bug: 2791310 */
943: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
944: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
945: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
946: WHERE PLAN_ID= -1
947: AND SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
948: AND ORDER_TYPE= 18
949: AND INVENTORY_ITEM_ID= c_rec.INVENTORY_ITEM_ID

Line 947: AND SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id

943: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
944: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
945: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
946: WHERE PLAN_ID= -1
947: AND SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
948: AND ORDER_TYPE= 18
949: AND INVENTORY_ITEM_ID= c_rec.INVENTORY_ITEM_ID
950: AND ORGANIZATION_ID= c_rec.ORGANIZATION_ID
951: AND NVL(SUBINVENTORY_CODE, MSC_UTIL.NULL_CHAR)= NVL( c_rec.SUBINVENTORY_CODE, MSC_UTIL.NULL_CHAR)

Line 962: ELSIF (MSC_CL_COLLECTION.v_is_incremental_refresh and c_rec.ORDER_TYPE= 5) or

958: AND NVL(PLANNING_PARTNER_SITE_ID,MSC_UTIL.NULL_VALUE)= NVL(c_rec.PLANNING_PARTNER_SITE_ID,MSC_UTIL.NULL_VALUE)
959: AND NVL(PLANNING_TP_TYPE,MSC_UTIL.NULL_VALUE)= NVL(c_rec.PLANNING_TP_TYPE,MSC_UTIL.NULL_VALUE);
960:
961: /* planned order */
962: ELSIF (MSC_CL_COLLECTION.v_is_incremental_refresh and c_rec.ORDER_TYPE= 5) or
963: (MSC_CL_COLLECTION.v_is_cont_refresh and (c_rec.ORDER_TYPE = 5) and
964: (MSC_CL_COLLECTION.v_coll_prec.mps_sn_flag = MSC_UTIL.SYS_INCR)) THEN -- MPS
965:
966:

Line 963: (MSC_CL_COLLECTION.v_is_cont_refresh and (c_rec.ORDER_TYPE = 5) and

959: AND NVL(PLANNING_TP_TYPE,MSC_UTIL.NULL_VALUE)= NVL(c_rec.PLANNING_TP_TYPE,MSC_UTIL.NULL_VALUE);
960:
961: /* planned order */
962: ELSIF (MSC_CL_COLLECTION.v_is_incremental_refresh and c_rec.ORDER_TYPE= 5) or
963: (MSC_CL_COLLECTION.v_is_cont_refresh and (c_rec.ORDER_TYPE = 5) and
964: (MSC_CL_COLLECTION.v_coll_prec.mps_sn_flag = MSC_UTIL.SYS_INCR)) THEN -- MPS
965:
966:
967: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'load_supply: upd MPS-0');

Line 964: (MSC_CL_COLLECTION.v_coll_prec.mps_sn_flag = MSC_UTIL.SYS_INCR)) THEN -- MPS

960:
961: /* planned order */
962: ELSIF (MSC_CL_COLLECTION.v_is_incremental_refresh and c_rec.ORDER_TYPE= 5) or
963: (MSC_CL_COLLECTION.v_is_cont_refresh and (c_rec.ORDER_TYPE = 5) and
964: (MSC_CL_COLLECTION.v_coll_prec.mps_sn_flag = MSC_UTIL.SYS_INCR)) THEN -- MPS
965:
966:
967: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'load_supply: upd MPS-0');
968:

Line 975: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,

971: SET OLD_NEW_SCHEDULE_DATE = NEW_SCHEDULE_DATE,
972: OLD_NEW_ORDER_QUANTITY = NEW_ORDER_QUANTITY,
973: NEW_ORDER_QUANTITY= 0.0,
974: DAILY_RATE= 0.0,
975: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
976: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
977: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
978: WHERE PLAN_ID= -1
979: AND SR_INSTANCE_ID= c_rec.SR_INSTANCE_ID

Line 976: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,

972: OLD_NEW_ORDER_QUANTITY = NEW_ORDER_QUANTITY,
973: NEW_ORDER_QUANTITY= 0.0,
974: DAILY_RATE= 0.0,
975: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
976: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
977: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
978: WHERE PLAN_ID= -1
979: AND SR_INSTANCE_ID= c_rec.SR_INSTANCE_ID
980: AND DISPOSITION_ID= c_rec.DISPOSITION_ID

Line 977: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user

973: NEW_ORDER_QUANTITY= 0.0,
974: DAILY_RATE= 0.0,
975: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
976: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
977: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
978: WHERE PLAN_ID= -1
979: AND SR_INSTANCE_ID= c_rec.SR_INSTANCE_ID
980: AND DISPOSITION_ID= c_rec.DISPOSITION_ID
981: AND ORDER_TYPE= c_rec.ORDER_TYPE

Line 984: ELSIF (MSC_CL_COLLECTION.v_is_incremental_refresh and c_rec.ORDER_TYPE= 41) or

980: AND DISPOSITION_ID= c_rec.DISPOSITION_ID
981: AND ORDER_TYPE= c_rec.ORDER_TYPE
982: AND ORGANIZATION_ID = c_rec.ORGANIZATION_ID;
983:
984: ELSIF (MSC_CL_COLLECTION.v_is_incremental_refresh and c_rec.ORDER_TYPE= 41) or
985: (MSC_CL_COLLECTION.v_is_cont_refresh and (c_rec.ORDER_TYPE = 41) and
986: (MSC_CL_COLLECTION.v_coll_prec.usup_sn_flag = MSC_UTIL.SYS_INCR)) THEN -- USER DEFINED
987:
988: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'load_supply: upd USUP-0');

Line 985: (MSC_CL_COLLECTION.v_is_cont_refresh and (c_rec.ORDER_TYPE = 41) and

981: AND ORDER_TYPE= c_rec.ORDER_TYPE
982: AND ORGANIZATION_ID = c_rec.ORGANIZATION_ID;
983:
984: ELSIF (MSC_CL_COLLECTION.v_is_incremental_refresh and c_rec.ORDER_TYPE= 41) or
985: (MSC_CL_COLLECTION.v_is_cont_refresh and (c_rec.ORDER_TYPE = 41) and
986: (MSC_CL_COLLECTION.v_coll_prec.usup_sn_flag = MSC_UTIL.SYS_INCR)) THEN -- USER DEFINED
987:
988: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'load_supply: upd USUP-0');
989:

Line 986: (MSC_CL_COLLECTION.v_coll_prec.usup_sn_flag = MSC_UTIL.SYS_INCR)) THEN -- USER DEFINED

982: AND ORGANIZATION_ID = c_rec.ORGANIZATION_ID;
983:
984: ELSIF (MSC_CL_COLLECTION.v_is_incremental_refresh and c_rec.ORDER_TYPE= 41) or
985: (MSC_CL_COLLECTION.v_is_cont_refresh and (c_rec.ORDER_TYPE = 41) and
986: (MSC_CL_COLLECTION.v_coll_prec.usup_sn_flag = MSC_UTIL.SYS_INCR)) THEN -- USER DEFINED
987:
988: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'load_supply: upd USUP-0');
989:
990:

Line 995: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,

991: UPDATE MSC_SUPPLIES
992: SET OLD_NEW_SCHEDULE_DATE = NEW_SCHEDULE_DATE,
993: OLD_NEW_ORDER_QUANTITY = NEW_ORDER_QUANTITY,
994: NEW_ORDER_QUANTITY= 0.0,
995: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
996: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
997: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
998: WHERE PLAN_ID= -1
999: AND SR_INSTANCE_ID= c_rec.SR_INSTANCE_ID

Line 996: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,

992: SET OLD_NEW_SCHEDULE_DATE = NEW_SCHEDULE_DATE,
993: OLD_NEW_ORDER_QUANTITY = NEW_ORDER_QUANTITY,
994: NEW_ORDER_QUANTITY= 0.0,
995: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
996: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
997: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
998: WHERE PLAN_ID= -1
999: AND SR_INSTANCE_ID= c_rec.SR_INSTANCE_ID
1000: AND DISPOSITION_ID= c_rec.DISPOSITION_ID

Line 997: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user

993: OLD_NEW_ORDER_QUANTITY = NEW_ORDER_QUANTITY,
994: NEW_ORDER_QUANTITY= 0.0,
995: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
996: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
997: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
998: WHERE PLAN_ID= -1
999: AND SR_INSTANCE_ID= c_rec.SR_INSTANCE_ID
1000: AND DISPOSITION_ID= c_rec.DISPOSITION_ID
1001: AND ORDER_TYPE= c_rec.ORDER_TYPE

Line 1008: IF c_count> MSC_CL_COLLECTION.PBS THEN

1004: END IF; -- ORDER_TYPE
1005:
1006: c_count:= c_count+1;
1007:
1008: IF c_count> MSC_CL_COLLECTION.PBS THEN
1009: COMMIT;
1010: c_count:= 0;
1011: END IF;
1012:

Line 1022: And sr_instance_id = MSC_CL_COLLECTION.v_instance_id

1018: Delete from msc_supplies
1019: Where DISPOSITION_ID = c_rec.DISPOSITION_ID
1020: And organization_id = c_rec.organization_id
1021: And order_type = c_rec.order_type
1022: And sr_instance_id = MSC_CL_COLLECTION.v_instance_id
1023: And plan_id = -1;
1024:
1025: END LOOP; -- c10_d
1026:

Line 1029: IF MSC_CL_COLLECTION.v_is_complete_refresh THEN

1025: END LOOP; -- c10_d
1026:
1027: END IF; -- refresh type
1028:
1029: IF MSC_CL_COLLECTION.v_is_complete_refresh THEN
1030: COMMIT;
1031: END IF;
1032:
1033:

Line 1130: IF (MSC_CL_COLLECTION.v_is_incremental_refresh or MSC_CL_COLLECTION.v_is_cont_refresh) THEN

1126: END IF ;
1127: END IF ;
1128: /* end bug 5937871*/
1129:
1130: IF (MSC_CL_COLLECTION.v_is_incremental_refresh or MSC_CL_COLLECTION.v_is_cont_refresh) THEN
1131:
1132: --=================== PO SUPPLIES =====================
1133:
1134: IF (MSC_CL_COLLECTION.v_is_incremental_refresh and c_rec.ORDER_TYPE IN (1,2,8,11,12,73,74,87)) or

Line 1134: IF (MSC_CL_COLLECTION.v_is_incremental_refresh and c_rec.ORDER_TYPE IN (1,2,8,11,12,73,74,87)) or

1130: IF (MSC_CL_COLLECTION.v_is_incremental_refresh or MSC_CL_COLLECTION.v_is_cont_refresh) THEN
1131:
1132: --=================== PO SUPPLIES =====================
1133:
1134: IF (MSC_CL_COLLECTION.v_is_incremental_refresh and c_rec.ORDER_TYPE IN (1,2,8,11,12,73,74,87)) or
1135: (MSC_CL_COLLECTION.v_is_cont_refresh and (c_rec.ORDER_TYPE IN (1,2,8,11,12,73,74,87)) and
1136: (MSC_CL_COLLECTION.v_coll_prec.po_sn_flag = MSC_UTIL.SYS_INCR)) THEN -- PO
1137:
1138: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'load_supply: upd PO');

Line 1135: (MSC_CL_COLLECTION.v_is_cont_refresh and (c_rec.ORDER_TYPE IN (1,2,8,11,12,73,74,87)) and

1131:
1132: --=================== PO SUPPLIES =====================
1133:
1134: IF (MSC_CL_COLLECTION.v_is_incremental_refresh and c_rec.ORDER_TYPE IN (1,2,8,11,12,73,74,87)) or
1135: (MSC_CL_COLLECTION.v_is_cont_refresh and (c_rec.ORDER_TYPE IN (1,2,8,11,12,73,74,87)) and
1136: (MSC_CL_COLLECTION.v_coll_prec.po_sn_flag = MSC_UTIL.SYS_INCR)) THEN -- PO
1137:
1138: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'load_supply: upd PO');
1139:

Line 1136: (MSC_CL_COLLECTION.v_coll_prec.po_sn_flag = MSC_UTIL.SYS_INCR)) THEN -- PO

1132: --=================== PO SUPPLIES =====================
1133:
1134: IF (MSC_CL_COLLECTION.v_is_incremental_refresh and c_rec.ORDER_TYPE IN (1,2,8,11,12,73,74,87)) or
1135: (MSC_CL_COLLECTION.v_is_cont_refresh and (c_rec.ORDER_TYPE IN (1,2,8,11,12,73,74,87)) and
1136: (MSC_CL_COLLECTION.v_coll_prec.po_sn_flag = MSC_UTIL.SYS_INCR)) THEN -- PO
1137:
1138: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'load_supply: upd PO');
1139:
1140:

Line 1151: OLD_NEW_ORDER_QUANTITY= decode(REFRESH_NUMBER,MSC_CL_COLLECTION.v_last_collection_id,OLD_NEW_ORDER_QUANTITY,NEW_ORDER_QUANTITY),

1147: OLD_FIRST_UNIT_START_DATE= FIRST_UNIT_START_DATE,
1148: OLD_LAST_UNIT_COMPLETION_DATE= LAST_UNIT_COMPLETION_DATE,
1149: OLD_NEW_SCHEDULE_DATE= NEW_SCHEDULE_DATE,
1150: OLD_QTY_COMPLETED= QTY_COMPLETED,
1151: OLD_NEW_ORDER_QUANTITY= decode(REFRESH_NUMBER,MSC_CL_COLLECTION.v_last_collection_id,OLD_NEW_ORDER_QUANTITY,NEW_ORDER_QUANTITY),
1152: OLD_FIRM_QUANTITY= FIRM_QUANTITY,
1153: OLD_FIRM_DATE= FIRM_DATE,
1154: INVENTORY_ITEM_ID= c_rec.INVENTORY_ITEM_ID,
1155: ORGANIZATION_ID= c_rec.ORGANIZATION_ID,

Line 1228: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,

1224: DEMAND_CLASS= c_rec.DEMAND_CLASS,
1225: VMI_FLAG=c_rec.VMI_FLAG,
1226: PO_LINE_LOCATION_ID = c_rec.PO_LINE_LOCATION_ID,
1227: PO_DISTRIBUTION_ID = c_rec.PO_DISTRIBUTION_ID,
1228: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
1229: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
1230: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user,
1231: /* CP-ACK starts */
1232: PROMISED_DATE = c_rec.PROMISED_DATE,

Line 1229: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,

1225: VMI_FLAG=c_rec.VMI_FLAG,
1226: PO_LINE_LOCATION_ID = c_rec.PO_LINE_LOCATION_ID,
1227: PO_DISTRIBUTION_ID = c_rec.PO_DISTRIBUTION_ID,
1228: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
1229: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
1230: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user,
1231: /* CP-ACK starts */
1232: PROMISED_DATE = c_rec.PROMISED_DATE,
1233: NEED_BY_DATE = c_rec.NEED_BY_DATE,

Line 1230: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user,

1226: PO_LINE_LOCATION_ID = c_rec.PO_LINE_LOCATION_ID,
1227: PO_DISTRIBUTION_ID = c_rec.PO_DISTRIBUTION_ID,
1228: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
1229: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
1230: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user,
1231: /* CP-ACK starts */
1232: PROMISED_DATE = c_rec.PROMISED_DATE,
1233: NEED_BY_DATE = c_rec.NEED_BY_DATE,
1234: ACCEPTANCE_REQUIRED_FLAG = c_rec.ACCEPTANCE_REQUIRED_FLAG,

Line 1253: ELSIF (MSC_CL_COLLECTION.v_is_incremental_refresh and c_rec.ORDER_TYPE IN (3,7,27,70,75,86)) or /* 70 eam supply*/

1249:
1250: END IF;
1251:
1252: --=================== WIP JOB SUPPLIES =====================
1253: ELSIF (MSC_CL_COLLECTION.v_is_incremental_refresh and c_rec.ORDER_TYPE IN (3,7,27,70,75,86)) or /* 70 eam supply*/
1254: (MSC_CL_COLLECTION.v_is_cont_refresh and (c_rec.ORDER_TYPE IN (3,7,27,70)) and
1255: (MSC_CL_COLLECTION.v_coll_prec.wip_sn_flag = MSC_UTIL.SYS_INCR)) THEN -- WIP_JOB
1256:
1257:

Line 1254: (MSC_CL_COLLECTION.v_is_cont_refresh and (c_rec.ORDER_TYPE IN (3,7,27,70)) and

1250: END IF;
1251:
1252: --=================== WIP JOB SUPPLIES =====================
1253: ELSIF (MSC_CL_COLLECTION.v_is_incremental_refresh and c_rec.ORDER_TYPE IN (3,7,27,70,75,86)) or /* 70 eam supply*/
1254: (MSC_CL_COLLECTION.v_is_cont_refresh and (c_rec.ORDER_TYPE IN (3,7,27,70)) and
1255: (MSC_CL_COLLECTION.v_coll_prec.wip_sn_flag = MSC_UTIL.SYS_INCR)) THEN -- WIP_JOB
1256:
1257:
1258: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'load_supply: upd WIP JOB');

Line 1255: (MSC_CL_COLLECTION.v_coll_prec.wip_sn_flag = MSC_UTIL.SYS_INCR)) THEN -- WIP_JOB

1251:
1252: --=================== WIP JOB SUPPLIES =====================
1253: ELSIF (MSC_CL_COLLECTION.v_is_incremental_refresh and c_rec.ORDER_TYPE IN (3,7,27,70,75,86)) or /* 70 eam supply*/
1254: (MSC_CL_COLLECTION.v_is_cont_refresh and (c_rec.ORDER_TYPE IN (3,7,27,70)) and
1255: (MSC_CL_COLLECTION.v_coll_prec.wip_sn_flag = MSC_UTIL.SYS_INCR)) THEN -- WIP_JOB
1256:
1257:
1258: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'load_supply: upd WIP JOB');
1259:

Line 1269: OLD_NEW_ORDER_QUANTITY= decode(REFRESH_NUMBER,MSC_CL_COLLECTION.v_last_collection_id,OLD_NEW_ORDER_QUANTITY,NEW_ORDER_QUANTITY),

1265: OLD_FIRST_UNIT_START_DATE= FIRST_UNIT_START_DATE,
1266: OLD_LAST_UNIT_COMPLETION_DATE= LAST_UNIT_COMPLETION_DATE,
1267: OLD_NEW_SCHEDULE_DATE= NEW_SCHEDULE_DATE,
1268: OLD_QTY_COMPLETED= QTY_COMPLETED,
1269: OLD_NEW_ORDER_QUANTITY= decode(REFRESH_NUMBER,MSC_CL_COLLECTION.v_last_collection_id,OLD_NEW_ORDER_QUANTITY,NEW_ORDER_QUANTITY),
1270: OLD_FIRM_QUANTITY= FIRM_QUANTITY,
1271: OLD_FIRM_DATE= FIRM_DATE,
1272: INVENTORY_ITEM_ID= c_rec.INVENTORY_ITEM_ID,
1273: ORGANIZATION_ID= c_rec.ORGANIZATION_ID,

Line 1348: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,

1344: WIP_SUPPLY_TYPE= c_rec.WIP_SUPPLY_TYPE,
1345: NON_NETTABLE_QTY=c_rec.NON_NETTABLE_QTY,
1346: LOT_NUMBER= c_rec.LOT_NUMBER,
1347: DEMAND_CLASS= c_rec.DEMAND_CLASS,
1348: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
1349: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
1350: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user,
1351: COPRODUCTS_SUPPLY = c_rec.COPRODUCTS_SUPPLY,
1352: /* ds change start */

Line 1349: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,

1345: NON_NETTABLE_QTY=c_rec.NON_NETTABLE_QTY,
1346: LOT_NUMBER= c_rec.LOT_NUMBER,
1347: DEMAND_CLASS= c_rec.DEMAND_CLASS,
1348: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
1349: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
1350: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user,
1351: COPRODUCTS_SUPPLY = c_rec.COPRODUCTS_SUPPLY,
1352: /* ds change start */
1353: REQUESTED_START_DATE = c_rec.REQUESTED_START_DATE,

Line 1350: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user,

1346: LOT_NUMBER= c_rec.LOT_NUMBER,
1347: DEMAND_CLASS= c_rec.DEMAND_CLASS,
1348: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
1349: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
1350: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user,
1351: COPRODUCTS_SUPPLY = c_rec.COPRODUCTS_SUPPLY,
1352: /* ds change start */
1353: REQUESTED_START_DATE = c_rec.REQUESTED_START_DATE,
1354: REQUESTED_COMPLETION_DATE = c_rec.REQUESTED_COMPLETION_DATE,

Line 1370: ELSIF (MSC_CL_COLLECTION.v_is_incremental_refresh and c_rec.ORDER_TYPE IN (14,15)) or

1366: AND DISPOSITION_ID= c_rec.DISPOSITION_ID
1367: AND ORGANIZATION_ID = c_rec.ORGANIZATION_ID;
1368:
1369: --=================== WIP DISCRETE JOB COMPONENT SUPPLIES =====================
1370: ELSIF (MSC_CL_COLLECTION.v_is_incremental_refresh and c_rec.ORDER_TYPE IN (14,15)) or
1371: (MSC_CL_COLLECTION.v_is_cont_refresh and (c_rec.ORDER_TYPE IN (14,15)) and
1372: (MSC_CL_COLLECTION.v_coll_prec.wip_sn_flag = MSC_UTIL.SYS_INCR)) THEN -- DISCRETE JOB COMPONENT
1373:
1374: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'load_supply: upd WIP DSC JOB');

Line 1371: (MSC_CL_COLLECTION.v_is_cont_refresh and (c_rec.ORDER_TYPE IN (14,15)) and

1367: AND ORGANIZATION_ID = c_rec.ORGANIZATION_ID;
1368:
1369: --=================== WIP DISCRETE JOB COMPONENT SUPPLIES =====================
1370: ELSIF (MSC_CL_COLLECTION.v_is_incremental_refresh and c_rec.ORDER_TYPE IN (14,15)) or
1371: (MSC_CL_COLLECTION.v_is_cont_refresh and (c_rec.ORDER_TYPE IN (14,15)) and
1372: (MSC_CL_COLLECTION.v_coll_prec.wip_sn_flag = MSC_UTIL.SYS_INCR)) THEN -- DISCRETE JOB COMPONENT
1373:
1374: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'load_supply: upd WIP DSC JOB');
1375:

Line 1372: (MSC_CL_COLLECTION.v_coll_prec.wip_sn_flag = MSC_UTIL.SYS_INCR)) THEN -- DISCRETE JOB COMPONENT

1368:
1369: --=================== WIP DISCRETE JOB COMPONENT SUPPLIES =====================
1370: ELSIF (MSC_CL_COLLECTION.v_is_incremental_refresh and c_rec.ORDER_TYPE IN (14,15)) or
1371: (MSC_CL_COLLECTION.v_is_cont_refresh and (c_rec.ORDER_TYPE IN (14,15)) and
1372: (MSC_CL_COLLECTION.v_coll_prec.wip_sn_flag = MSC_UTIL.SYS_INCR)) THEN -- DISCRETE JOB COMPONENT
1373:
1374: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'load_supply: upd WIP DSC JOB');
1375:
1376:

Line 1385: OLD_NEW_ORDER_QUANTITY= decode(REFRESH_NUMBER,MSC_CL_COLLECTION.v_last_collection_id,OLD_NEW_ORDER_QUANTITY,NEW_ORDER_QUANTITY),

1381: OLD_FIRST_UNIT_START_DATE= FIRST_UNIT_START_DATE,
1382: OLD_LAST_UNIT_COMPLETION_DATE= LAST_UNIT_COMPLETION_DATE,
1383: OLD_NEW_SCHEDULE_DATE= NEW_SCHEDULE_DATE,
1384: OLD_QTY_COMPLETED= QTY_COMPLETED,
1385: OLD_NEW_ORDER_QUANTITY= decode(REFRESH_NUMBER,MSC_CL_COLLECTION.v_last_collection_id,OLD_NEW_ORDER_QUANTITY,NEW_ORDER_QUANTITY),
1386: OLD_FIRM_QUANTITY= FIRM_QUANTITY,
1387: OLD_FIRM_DATE= FIRM_DATE,
1388: ORGANIZATION_ID= c_rec.ORGANIZATION_ID,
1389: REVISION= c_rec.REVISION,

Line 1461: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,

1457: WIP_SUPPLY_TYPE= c_rec.WIP_SUPPLY_TYPE,
1458: NON_NETTABLE_QTY=c_rec.NON_NETTABLE_QTY,
1459: LOT_NUMBER= c_rec.LOT_NUMBER,
1460: DEMAND_CLASS= c_rec.DEMAND_CLASS,
1461: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
1462: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
1463: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user,
1464: COPRODUCTS_SUPPLY = c_rec.COPRODUCTS_SUPPLY,
1465: /* ds change start */

Line 1462: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,

1458: NON_NETTABLE_QTY=c_rec.NON_NETTABLE_QTY,
1459: LOT_NUMBER= c_rec.LOT_NUMBER,
1460: DEMAND_CLASS= c_rec.DEMAND_CLASS,
1461: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
1462: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
1463: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user,
1464: COPRODUCTS_SUPPLY = c_rec.COPRODUCTS_SUPPLY,
1465: /* ds change start */
1466: REQUESTED_START_DATE = c_rec.REQUESTED_START_DATE,

Line 1463: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user,

1459: LOT_NUMBER= c_rec.LOT_NUMBER,
1460: DEMAND_CLASS= c_rec.DEMAND_CLASS,
1461: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
1462: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
1463: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user,
1464: COPRODUCTS_SUPPLY = c_rec.COPRODUCTS_SUPPLY,
1465: /* ds change start */
1466: REQUESTED_START_DATE = c_rec.REQUESTED_START_DATE,
1467: REQUESTED_COMPLETION_DATE = c_rec.REQUESTED_COMPLETION_DATE,

Line 1484: ELSIF (MSC_CL_COLLECTION.v_is_incremental_refresh and c_rec.ORDER_TYPE= 30) or

1480: AND OPERATION_SEQ_NUM= c_rec.OPERATION_SEQ_NUM
1481: AND ORGANIZATION_ID = c_rec.ORGANIZATION_ID;
1482:
1483: --=================== REPETITIVE ITEM SUPPLIES =====================
1484: ELSIF (MSC_CL_COLLECTION.v_is_incremental_refresh and c_rec.ORDER_TYPE= 30) or
1485: (MSC_CL_COLLECTION.v_is_cont_refresh and (c_rec.ORDER_TYPE = 30) and
1486: (MSC_CL_COLLECTION.v_coll_prec.wip_sn_flag = MSC_UTIL.SYS_INCR)) THEN -- REPT ITEM
1487:
1488: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'load_supply: upd REPT ITEMS');

Line 1485: (MSC_CL_COLLECTION.v_is_cont_refresh and (c_rec.ORDER_TYPE = 30) and

1481: AND ORGANIZATION_ID = c_rec.ORGANIZATION_ID;
1482:
1483: --=================== REPETITIVE ITEM SUPPLIES =====================
1484: ELSIF (MSC_CL_COLLECTION.v_is_incremental_refresh and c_rec.ORDER_TYPE= 30) or
1485: (MSC_CL_COLLECTION.v_is_cont_refresh and (c_rec.ORDER_TYPE = 30) and
1486: (MSC_CL_COLLECTION.v_coll_prec.wip_sn_flag = MSC_UTIL.SYS_INCR)) THEN -- REPT ITEM
1487:
1488: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'load_supply: upd REPT ITEMS');
1489:

Line 1486: (MSC_CL_COLLECTION.v_coll_prec.wip_sn_flag = MSC_UTIL.SYS_INCR)) THEN -- REPT ITEM

1482:
1483: --=================== REPETITIVE ITEM SUPPLIES =====================
1484: ELSIF (MSC_CL_COLLECTION.v_is_incremental_refresh and c_rec.ORDER_TYPE= 30) or
1485: (MSC_CL_COLLECTION.v_is_cont_refresh and (c_rec.ORDER_TYPE = 30) and
1486: (MSC_CL_COLLECTION.v_coll_prec.wip_sn_flag = MSC_UTIL.SYS_INCR)) THEN -- REPT ITEM
1487:
1488: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'load_supply: upd REPT ITEMS');
1489:
1490: /* ATP SUMMARY CHANGES Added the OLD_**** Columns */

Line 1498: OLD_NEW_ORDER_QUANTITY= decode(REFRESH_NUMBER,MSC_CL_COLLECTION.v_last_collection_id,OLD_NEW_ORDER_QUANTITY,NEW_ORDER_QUANTITY),

1494: OLD_FIRST_UNIT_START_DATE= FIRST_UNIT_START_DATE,
1495: OLD_LAST_UNIT_COMPLETION_DATE= LAST_UNIT_COMPLETION_DATE,
1496: OLD_NEW_SCHEDULE_DATE= NEW_SCHEDULE_DATE,
1497: OLD_QTY_COMPLETED= QTY_COMPLETED,
1498: OLD_NEW_ORDER_QUANTITY= decode(REFRESH_NUMBER,MSC_CL_COLLECTION.v_last_collection_id,OLD_NEW_ORDER_QUANTITY,NEW_ORDER_QUANTITY),
1499: OLD_FIRM_QUANTITY= FIRM_QUANTITY,
1500: OLD_FIRM_DATE= FIRM_DATE,
1501: INVENTORY_ITEM_ID= c_rec.INVENTORY_ITEM_ID,
1502: ORGANIZATION_ID= c_rec.ORGANIZATION_ID,

Line 1571: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,

1567: WIP_STATUS_CODE= c_rec.WIP_STATUS_CODE,
1568: WIP_SUPPLY_TYPE= c_rec.WIP_SUPPLY_TYPE,
1569: LOT_NUMBER= c_rec.LOT_NUMBER,
1570: DEMAND_CLASS= c_rec.DEMAND_CLASS,
1571: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
1572: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
1573: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user,
1574: COPRODUCTS_SUPPLY = c_rec.COPRODUCTS_SUPPLY,
1575: RO_CREATION_DATE =c_rec.RO_CREATION_DATE,

Line 1572: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,

1568: WIP_SUPPLY_TYPE= c_rec.WIP_SUPPLY_TYPE,
1569: LOT_NUMBER= c_rec.LOT_NUMBER,
1570: DEMAND_CLASS= c_rec.DEMAND_CLASS,
1571: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
1572: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
1573: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user,
1574: COPRODUCTS_SUPPLY = c_rec.COPRODUCTS_SUPPLY,
1575: RO_CREATION_DATE =c_rec.RO_CREATION_DATE,
1576: REPAIR_LEAD_TIME= c_rec.REPAIR_LEAD_TIME

Line 1573: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user,

1569: LOT_NUMBER= c_rec.LOT_NUMBER,
1570: DEMAND_CLASS= c_rec.DEMAND_CLASS,
1571: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
1572: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
1573: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user,
1574: COPRODUCTS_SUPPLY = c_rec.COPRODUCTS_SUPPLY,
1575: RO_CREATION_DATE =c_rec.RO_CREATION_DATE,
1576: REPAIR_LEAD_TIME= c_rec.REPAIR_LEAD_TIME
1577: WHERE PLAN_ID= -1

Line 1584: ELSIF (MSC_CL_COLLECTION.v_is_incremental_refresh and c_rec.ORDER_TYPE= 18) or

1580: AND DISPOSITION_ID= c_rec.DISPOSITION_ID
1581: AND ORGANIZATION_ID = c_rec.ORGANIZATION_ID;
1582:
1583: --=================== ONHAND SUPPLIES =====================
1584: ELSIF (MSC_CL_COLLECTION.v_is_incremental_refresh and c_rec.ORDER_TYPE= 18) or
1585: (MSC_CL_COLLECTION.v_is_cont_refresh and (c_rec.ORDER_TYPE = 18) and
1586: (MSC_CL_COLLECTION.v_coll_prec.oh_sn_flag = MSC_UTIL.SYS_INCR)) THEN -- ONHAND
1587:
1588:

Line 1585: (MSC_CL_COLLECTION.v_is_cont_refresh and (c_rec.ORDER_TYPE = 18) and

1581: AND ORGANIZATION_ID = c_rec.ORGANIZATION_ID;
1582:
1583: --=================== ONHAND SUPPLIES =====================
1584: ELSIF (MSC_CL_COLLECTION.v_is_incremental_refresh and c_rec.ORDER_TYPE= 18) or
1585: (MSC_CL_COLLECTION.v_is_cont_refresh and (c_rec.ORDER_TYPE = 18) and
1586: (MSC_CL_COLLECTION.v_coll_prec.oh_sn_flag = MSC_UTIL.SYS_INCR)) THEN -- ONHAND
1587:
1588:
1589: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'load_supply: upd OH');

Line 1586: (MSC_CL_COLLECTION.v_coll_prec.oh_sn_flag = MSC_UTIL.SYS_INCR)) THEN -- ONHAND

1582:
1583: --=================== ONHAND SUPPLIES =====================
1584: ELSIF (MSC_CL_COLLECTION.v_is_incremental_refresh and c_rec.ORDER_TYPE= 18) or
1585: (MSC_CL_COLLECTION.v_is_cont_refresh and (c_rec.ORDER_TYPE = 18) and
1586: (MSC_CL_COLLECTION.v_coll_prec.oh_sn_flag = MSC_UTIL.SYS_INCR)) THEN -- ONHAND
1587:
1588:
1589: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'load_supply: upd OH');
1590:

Line 1600: OLD_NEW_ORDER_QUANTITY= decode(REFRESH_NUMBER,MSC_CL_COLLECTION.v_last_collection_id,OLD_NEW_ORDER_QUANTITY,NEW_ORDER_QUANTITY),

1596: OLD_FIRST_UNIT_START_DATE= FIRST_UNIT_START_DATE,
1597: OLD_LAST_UNIT_COMPLETION_DATE= LAST_UNIT_COMPLETION_DATE,
1598: OLD_NEW_SCHEDULE_DATE= NEW_SCHEDULE_DATE,
1599: OLD_QTY_COMPLETED= QTY_COMPLETED,
1600: OLD_NEW_ORDER_QUANTITY= decode(REFRESH_NUMBER,MSC_CL_COLLECTION.v_last_collection_id,OLD_NEW_ORDER_QUANTITY,NEW_ORDER_QUANTITY),
1601: OLD_FIRM_QUANTITY= FIRM_QUANTITY,
1602: OLD_FIRM_DATE= FIRM_DATE,
1603: NEW_ORDER_QUANTITY= c_rec.NEW_ORDER_QUANTITY,
1604: NEW_SCHEDULE_DATE=lv_schedule_date,

Line 1614: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,

1610: PLANNING_TP_TYPE=c_rec.PLANNING_TP_TYPE,
1611: OWNING_PARTNER_SITE_ID=c_rec.OWNING_PARTNER_SITE_ID,
1612: OWNING_TP_TYPE=c_rec.OWNING_TP_TYPE,
1613: VMI_FLAG=c_rec.VMI_FLAG,
1614: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
1615: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
1616: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user,
1617: COPRODUCTS_SUPPLY = c_rec.COPRODUCTS_SUPPLY,
1618: SR_CUSTOMER_ACCT_ID=c_rec.SR_CUSTOMER_ACCT_ID,

Line 1615: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,

1611: OWNING_PARTNER_SITE_ID=c_rec.OWNING_PARTNER_SITE_ID,
1612: OWNING_TP_TYPE=c_rec.OWNING_TP_TYPE,
1613: VMI_FLAG=c_rec.VMI_FLAG,
1614: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
1615: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
1616: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user,
1617: COPRODUCTS_SUPPLY = c_rec.COPRODUCTS_SUPPLY,
1618: SR_CUSTOMER_ACCT_ID=c_rec.SR_CUSTOMER_ACCT_ID,
1619: ITEM_TYPE_VALUE=c_rec.ITEM_TYPE_VALUE,

Line 1616: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user,

1612: OWNING_TP_TYPE=c_rec.OWNING_TP_TYPE,
1613: VMI_FLAG=c_rec.VMI_FLAG,
1614: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
1615: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
1616: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user,
1617: COPRODUCTS_SUPPLY = c_rec.COPRODUCTS_SUPPLY,
1618: SR_CUSTOMER_ACCT_ID=c_rec.SR_CUSTOMER_ACCT_ID,
1619: ITEM_TYPE_VALUE=c_rec.ITEM_TYPE_VALUE,
1620: ITEM_TYPE_ID=c_rec.ITEM_TYPE_ID,

Line 1639: ELSIF (MSC_CL_COLLECTION.v_is_incremental_refresh and c_rec.ORDER_TYPE= 5) or

1635: AND NVL(PLANNING_PARTNER_SITE_ID,MSC_UTIL.NULL_VALUE)= NVL(c_rec.PLANNING_PARTNER_SITE_ID,MSC_UTIL.NULL_VALUE)
1636: AND NVL(PLANNING_TP_TYPE,MSC_UTIL.NULL_VALUE)= NVL(c_rec.PLANNING_TP_TYPE,MSC_UTIL.NULL_VALUE);
1637:
1638: --=================== MPS SUPPLIES =====================
1639: ELSIF (MSC_CL_COLLECTION.v_is_incremental_refresh and c_rec.ORDER_TYPE= 5) or
1640: (MSC_CL_COLLECTION.v_is_cont_refresh and (c_rec.ORDER_TYPE = 5) and
1641: (MSC_CL_COLLECTION.v_coll_prec.mps_sn_flag = MSC_UTIL.SYS_INCR)) THEN -- MPS
1642:
1643: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'load_supply: upd MPS');

Line 1640: (MSC_CL_COLLECTION.v_is_cont_refresh and (c_rec.ORDER_TYPE = 5) and

1636: AND NVL(PLANNING_TP_TYPE,MSC_UTIL.NULL_VALUE)= NVL(c_rec.PLANNING_TP_TYPE,MSC_UTIL.NULL_VALUE);
1637:
1638: --=================== MPS SUPPLIES =====================
1639: ELSIF (MSC_CL_COLLECTION.v_is_incremental_refresh and c_rec.ORDER_TYPE= 5) or
1640: (MSC_CL_COLLECTION.v_is_cont_refresh and (c_rec.ORDER_TYPE = 5) and
1641: (MSC_CL_COLLECTION.v_coll_prec.mps_sn_flag = MSC_UTIL.SYS_INCR)) THEN -- MPS
1642:
1643: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'load_supply: upd MPS');
1644:

Line 1641: (MSC_CL_COLLECTION.v_coll_prec.mps_sn_flag = MSC_UTIL.SYS_INCR)) THEN -- MPS

1637:
1638: --=================== MPS SUPPLIES =====================
1639: ELSIF (MSC_CL_COLLECTION.v_is_incremental_refresh and c_rec.ORDER_TYPE= 5) or
1640: (MSC_CL_COLLECTION.v_is_cont_refresh and (c_rec.ORDER_TYPE = 5) and
1641: (MSC_CL_COLLECTION.v_coll_prec.mps_sn_flag = MSC_UTIL.SYS_INCR)) THEN -- MPS
1642:
1643: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'load_supply: upd MPS');
1644:
1645:

Line 1654: OLD_NEW_ORDER_QUANTITY= decode(REFRESH_NUMBER,MSC_CL_COLLECTION.v_last_collection_id,OLD_NEW_ORDER_QUANTITY,NEW_ORDER_QUANTITY),

1650: OLD_FIRST_UNIT_START_DATE= FIRST_UNIT_START_DATE,
1651: OLD_LAST_UNIT_COMPLETION_DATE= LAST_UNIT_COMPLETION_DATE,
1652: OLD_NEW_SCHEDULE_DATE= NEW_SCHEDULE_DATE,
1653: OLD_QTY_COMPLETED= QTY_COMPLETED,
1654: OLD_NEW_ORDER_QUANTITY= decode(REFRESH_NUMBER,MSC_CL_COLLECTION.v_last_collection_id,OLD_NEW_ORDER_QUANTITY,NEW_ORDER_QUANTITY),
1655: OLD_FIRM_QUANTITY= FIRM_QUANTITY,
1656: OLD_FIRM_DATE= FIRM_DATE,
1657: INVENTORY_ITEM_ID= c_rec.INVENTORY_ITEM_ID,
1658: ORGANIZATION_ID= c_rec.ORGANIZATION_ID,

Line 1728: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,

1724: QTY_COMPLETED= c_rec.QTY_COMPLETED,
1725: SCHEDULE_GROUP_NAME= c_rec.SCHEDULE_GROUP_NAME,
1726: LOT_NUMBER= c_rec.LOT_NUMBER,
1727: DEMAND_CLASS= c_rec.DEMAND_CLASS,
1728: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
1729: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
1730: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user,
1731: COPRODUCTS_SUPPLY = c_rec.COPRODUCTS_SUPPLY,
1732: /* ds change start */

Line 1729: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,

1725: SCHEDULE_GROUP_NAME= c_rec.SCHEDULE_GROUP_NAME,
1726: LOT_NUMBER= c_rec.LOT_NUMBER,
1727: DEMAND_CLASS= c_rec.DEMAND_CLASS,
1728: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
1729: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
1730: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user,
1731: COPRODUCTS_SUPPLY = c_rec.COPRODUCTS_SUPPLY,
1732: /* ds change start */
1733: REQUESTED_START_DATE = c_rec.REQUESTED_START_DATE,

Line 1730: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user,

1726: LOT_NUMBER= c_rec.LOT_NUMBER,
1727: DEMAND_CLASS= c_rec.DEMAND_CLASS,
1728: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
1729: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
1730: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user,
1731: COPRODUCTS_SUPPLY = c_rec.COPRODUCTS_SUPPLY,
1732: /* ds change start */
1733: REQUESTED_START_DATE = c_rec.REQUESTED_START_DATE,
1734: REQUESTED_COMPLETION_DATE = c_rec.REQUESTED_COMPLETION_DATE,

Line 1751: ELSIF (MSC_CL_COLLECTION.v_is_incremental_refresh and c_rec.ORDER_TYPE= 41) or

1747: AND ORDER_TYPE= c_rec.ORDER_TYPE
1748: AND ORGANIZATION_ID = c_rec.ORGANIZATION_ID;
1749:
1750: --=================== USER DEFINED SUPPLIES =====================
1751: ELSIF (MSC_CL_COLLECTION.v_is_incremental_refresh and c_rec.ORDER_TYPE= 41) or
1752: (MSC_CL_COLLECTION.v_is_cont_refresh and (c_rec.ORDER_TYPE = 41) and
1753: (MSC_CL_COLLECTION.v_coll_prec.usup_sn_flag = MSC_UTIL.SYS_INCR)) THEN -- USER DEFINED
1754:
1755: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'load_supply: upd USUP');

Line 1752: (MSC_CL_COLLECTION.v_is_cont_refresh and (c_rec.ORDER_TYPE = 41) and

1748: AND ORGANIZATION_ID = c_rec.ORGANIZATION_ID;
1749:
1750: --=================== USER DEFINED SUPPLIES =====================
1751: ELSIF (MSC_CL_COLLECTION.v_is_incremental_refresh and c_rec.ORDER_TYPE= 41) or
1752: (MSC_CL_COLLECTION.v_is_cont_refresh and (c_rec.ORDER_TYPE = 41) and
1753: (MSC_CL_COLLECTION.v_coll_prec.usup_sn_flag = MSC_UTIL.SYS_INCR)) THEN -- USER DEFINED
1754:
1755: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'load_supply: upd USUP');
1756:

Line 1753: (MSC_CL_COLLECTION.v_coll_prec.usup_sn_flag = MSC_UTIL.SYS_INCR)) THEN -- USER DEFINED

1749:
1750: --=================== USER DEFINED SUPPLIES =====================
1751: ELSIF (MSC_CL_COLLECTION.v_is_incremental_refresh and c_rec.ORDER_TYPE= 41) or
1752: (MSC_CL_COLLECTION.v_is_cont_refresh and (c_rec.ORDER_TYPE = 41) and
1753: (MSC_CL_COLLECTION.v_coll_prec.usup_sn_flag = MSC_UTIL.SYS_INCR)) THEN -- USER DEFINED
1754:
1755: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'load_supply: upd USUP');
1756:
1757:

Line 1766: OLD_NEW_ORDER_QUANTITY= decode(REFRESH_NUMBER,MSC_CL_COLLECTION.v_last_collection_id,OLD_NEW_ORDER_QUANTITY,NEW_ORDER_QUANTITY),

1762: OLD_FIRST_UNIT_START_DATE= FIRST_UNIT_START_DATE,
1763: OLD_LAST_UNIT_COMPLETION_DATE= LAST_UNIT_COMPLETION_DATE,
1764: OLD_NEW_SCHEDULE_DATE= NEW_SCHEDULE_DATE,
1765: OLD_QTY_COMPLETED= QTY_COMPLETED,
1766: OLD_NEW_ORDER_QUANTITY= decode(REFRESH_NUMBER,MSC_CL_COLLECTION.v_last_collection_id,OLD_NEW_ORDER_QUANTITY,NEW_ORDER_QUANTITY),
1767: OLD_FIRM_QUANTITY= FIRM_QUANTITY,
1768: OLD_FIRM_DATE= FIRM_DATE,
1769: INVENTORY_ITEM_ID= c_rec.INVENTORY_ITEM_ID,
1770: ORGANIZATION_ID= c_rec.ORGANIZATION_ID,

Line 1839: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,

1835: QTY_COMPLETED= c_rec.QTY_COMPLETED,
1836: SCHEDULE_GROUP_NAME= c_rec.SCHEDULE_GROUP_NAME,
1837: LOT_NUMBER= c_rec.LOT_NUMBER,
1838: DEMAND_CLASS= c_rec.DEMAND_CLASS,
1839: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
1840: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
1841: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user,
1842: COPRODUCTS_SUPPLY = c_rec.COPRODUCTS_SUPPLY,
1843: RO_CREATION_DATE =c_rec.RO_CREATION_DATE,

Line 1840: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,

1836: SCHEDULE_GROUP_NAME= c_rec.SCHEDULE_GROUP_NAME,
1837: LOT_NUMBER= c_rec.LOT_NUMBER,
1838: DEMAND_CLASS= c_rec.DEMAND_CLASS,
1839: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
1840: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
1841: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user,
1842: COPRODUCTS_SUPPLY = c_rec.COPRODUCTS_SUPPLY,
1843: RO_CREATION_DATE =c_rec.RO_CREATION_DATE,
1844: REPAIR_LEAD_TIME= c_rec.REPAIR_LEAD_TIME

Line 1841: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user,

1837: LOT_NUMBER= c_rec.LOT_NUMBER,
1838: DEMAND_CLASS= c_rec.DEMAND_CLASS,
1839: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
1840: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
1841: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user,
1842: COPRODUCTS_SUPPLY = c_rec.COPRODUCTS_SUPPLY,
1843: RO_CREATION_DATE =c_rec.RO_CREATION_DATE,
1844: REPAIR_LEAD_TIME= c_rec.REPAIR_LEAD_TIME
1845: WHERE PLAN_ID= -1

Line 1855: IF MSC_CL_COLLECTION.v_is_complete_refresh OR

1851: END IF; -- ORDER_TYPE
1852:
1853: END IF; -- refresh mode
1854:
1855: IF MSC_CL_COLLECTION.v_is_complete_refresh OR
1856: SQL%NOTFOUND OR
1857: c_rec.SR_MTL_SUPPLY_ID= -1 THEN
1858: if(SQL%NOTFOUND) Then
1859: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Load supply: not found:' || c_rec.SR_MTL_SUPPLY_ID);

Line 1963: MSC_CL_COLLECTION.v_last_collection_id,

1959: c_rec.VMI_FLAG,
1960: c_rec.PO_LINE_LOCATION_ID,
1961: c_rec.PO_DISTRIBUTION_ID,
1962: c_rec.SR_MTL_SUPPLY_ID,
1963: MSC_CL_COLLECTION.v_last_collection_id,
1964: MSC_CL_COLLECTION.v_current_date,
1965: MSC_CL_COLLECTION.v_current_user,
1966: MSC_CL_COLLECTION.v_current_date,
1967: MSC_CL_COLLECTION.v_current_user,

Line 1964: MSC_CL_COLLECTION.v_current_date,

1960: c_rec.PO_LINE_LOCATION_ID,
1961: c_rec.PO_DISTRIBUTION_ID,
1962: c_rec.SR_MTL_SUPPLY_ID,
1963: MSC_CL_COLLECTION.v_last_collection_id,
1964: MSC_CL_COLLECTION.v_current_date,
1965: MSC_CL_COLLECTION.v_current_user,
1966: MSC_CL_COLLECTION.v_current_date,
1967: MSC_CL_COLLECTION.v_current_user,
1968: /* CP-ACK starts */

Line 1965: MSC_CL_COLLECTION.v_current_user,

1961: c_rec.PO_DISTRIBUTION_ID,
1962: c_rec.SR_MTL_SUPPLY_ID,
1963: MSC_CL_COLLECTION.v_last_collection_id,
1964: MSC_CL_COLLECTION.v_current_date,
1965: MSC_CL_COLLECTION.v_current_user,
1966: MSC_CL_COLLECTION.v_current_date,
1967: MSC_CL_COLLECTION.v_current_user,
1968: /* CP-ACK starts */
1969: c_rec.ORIGINAL_NEED_BY_DATE,

Line 1966: MSC_CL_COLLECTION.v_current_date,

1962: c_rec.SR_MTL_SUPPLY_ID,
1963: MSC_CL_COLLECTION.v_last_collection_id,
1964: MSC_CL_COLLECTION.v_current_date,
1965: MSC_CL_COLLECTION.v_current_user,
1966: MSC_CL_COLLECTION.v_current_date,
1967: MSC_CL_COLLECTION.v_current_user,
1968: /* CP-ACK starts */
1969: c_rec.ORIGINAL_NEED_BY_DATE,
1970: c_rec.ORIGINAL_QUANTITY,

Line 1967: MSC_CL_COLLECTION.v_current_user,

1963: MSC_CL_COLLECTION.v_last_collection_id,
1964: MSC_CL_COLLECTION.v_current_date,
1965: MSC_CL_COLLECTION.v_current_user,
1966: MSC_CL_COLLECTION.v_current_date,
1967: MSC_CL_COLLECTION.v_current_user,
1968: /* CP-ACK starts */
1969: c_rec.ORIGINAL_NEED_BY_DATE,
1970: c_rec.ORIGINAL_QUANTITY,
1971: c_rec.PROMISED_DATE,

Line 2004: IF c_count> MSC_CL_COLLECTION.PBS THEN

2000: END IF;
2001:
2002: c_count:= c_count+1;
2003:
2004: IF c_count> MSC_CL_COLLECTION.PBS THEN
2005: IF MSC_CL_COLLECTION.v_is_complete_refresh THEN COMMIT; END IF;
2006: c_count:= 0;
2007: END IF;
2008: /* ds change */

Line 2005: IF MSC_CL_COLLECTION.v_is_complete_refresh THEN COMMIT; END IF;

2001:
2002: c_count:= c_count+1;
2003:
2004: IF c_count> MSC_CL_COLLECTION.PBS THEN
2005: IF MSC_CL_COLLECTION.v_is_complete_refresh THEN COMMIT; END IF;
2006: c_count:= 0;
2007: END IF;
2008: /* ds change */
2009: if c_rec.ORDER_TYPE = 70 then /* 70 eam supply*/

Line 2010: MSC_CL_COLLECTION.link_top_transaction_id_req := TRUE;

2006: c_count:= 0;
2007: END IF;
2008: /* ds change */
2009: if c_rec.ORDER_TYPE = 70 then /* 70 eam supply*/
2010: MSC_CL_COLLECTION.link_top_transaction_id_req := TRUE;
2011: end if;
2012: /* ds change */
2013:
2014: EXCEPTION

Line 2027: set SUPPLIES_LOAD_FLAG = MSC_CL_COLLECTION.G_JOB_ERROR

2023: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
2024: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2025:
2026: update msc_apps_instances
2027: set SUPPLIES_LOAD_FLAG = MSC_CL_COLLECTION.G_JOB_ERROR
2028: where instance_id = MSC_CL_COLLECTION.v_instance_id;
2029: commit;
2030:
2031: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 2028: where instance_id = MSC_CL_COLLECTION.v_instance_id;

2024: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2025:
2026: update msc_apps_instances
2027: set SUPPLIES_LOAD_FLAG = MSC_CL_COLLECTION.G_JOB_ERROR
2028: where instance_id = MSC_CL_COLLECTION.v_instance_id;
2029: commit;
2030:
2031: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2032: RAISE;

Line 2035: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

2031: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2032: RAISE;
2033:
2034: ELSE
2035: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2036:
2037: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'OTHER========================================');
2038: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2039: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');

Line 2052: MSC_CL_COLLECTION.v_instance_id));

2048: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2049: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2050: FND_MESSAGE.SET_TOKEN('VALUE',
2051: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
2052: MSC_CL_COLLECTION.v_instance_id));
2053: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2054:
2055: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2056: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORDER_TYPE');

Line 2078: IF (MSC_CL_COLLECTION.v_is_complete_refresh or MSC_CL_COLLECTION.v_is_incremental_refresh) THEN

2074:
2075: IF (MSC_UTIL.G_MSC_CONFIGURATION = MSC_UTIL.G_CONF_APS_SCE
2076: OR MSC_UTIL.G_MSC_CONFIGURATION = MSC_UTIL.G_CONF_SCE) THEN
2077:
2078: IF (MSC_CL_COLLECTION.v_is_complete_refresh or MSC_CL_COLLECTION.v_is_incremental_refresh) THEN
2079:
2080: MSC_CL_SUPPLIER_RESP.LOAD_SUPPLIER_RESPONSE
2081: ( MSC_CL_COLLECTION.v_instance_id,
2082: MSC_CL_COLLECTION.v_is_complete_refresh,

Line 2081: ( MSC_CL_COLLECTION.v_instance_id,

2077:
2078: IF (MSC_CL_COLLECTION.v_is_complete_refresh or MSC_CL_COLLECTION.v_is_incremental_refresh) THEN
2079:
2080: MSC_CL_SUPPLIER_RESP.LOAD_SUPPLIER_RESPONSE
2081: ( MSC_CL_COLLECTION.v_instance_id,
2082: MSC_CL_COLLECTION.v_is_complete_refresh,
2083: MSC_CL_COLLECTION.v_is_partial_refresh,
2084: MSC_CL_COLLECTION.v_is_incremental_refresh,
2085: lv_tbl,

Line 2082: MSC_CL_COLLECTION.v_is_complete_refresh,

2078: IF (MSC_CL_COLLECTION.v_is_complete_refresh or MSC_CL_COLLECTION.v_is_incremental_refresh) THEN
2079:
2080: MSC_CL_SUPPLIER_RESP.LOAD_SUPPLIER_RESPONSE
2081: ( MSC_CL_COLLECTION.v_instance_id,
2082: MSC_CL_COLLECTION.v_is_complete_refresh,
2083: MSC_CL_COLLECTION.v_is_partial_refresh,
2084: MSC_CL_COLLECTION.v_is_incremental_refresh,
2085: lv_tbl,
2086: MSC_CL_COLLECTION.v_current_user,

Line 2083: MSC_CL_COLLECTION.v_is_partial_refresh,

2079:
2080: MSC_CL_SUPPLIER_RESP.LOAD_SUPPLIER_RESPONSE
2081: ( MSC_CL_COLLECTION.v_instance_id,
2082: MSC_CL_COLLECTION.v_is_complete_refresh,
2083: MSC_CL_COLLECTION.v_is_partial_refresh,
2084: MSC_CL_COLLECTION.v_is_incremental_refresh,
2085: lv_tbl,
2086: MSC_CL_COLLECTION.v_current_user,
2087: MSC_CL_COLLECTION.v_last_collection_id);

Line 2084: MSC_CL_COLLECTION.v_is_incremental_refresh,

2080: MSC_CL_SUPPLIER_RESP.LOAD_SUPPLIER_RESPONSE
2081: ( MSC_CL_COLLECTION.v_instance_id,
2082: MSC_CL_COLLECTION.v_is_complete_refresh,
2083: MSC_CL_COLLECTION.v_is_partial_refresh,
2084: MSC_CL_COLLECTION.v_is_incremental_refresh,
2085: lv_tbl,
2086: MSC_CL_COLLECTION.v_current_user,
2087: MSC_CL_COLLECTION.v_last_collection_id);
2088:

Line 2086: MSC_CL_COLLECTION.v_current_user,

2082: MSC_CL_COLLECTION.v_is_complete_refresh,
2083: MSC_CL_COLLECTION.v_is_partial_refresh,
2084: MSC_CL_COLLECTION.v_is_incremental_refresh,
2085: lv_tbl,
2086: MSC_CL_COLLECTION.v_current_user,
2087: MSC_CL_COLLECTION.v_last_collection_id);
2088:
2089: ELSIF (MSC_CL_COLLECTION.v_is_cont_refresh) THEN
2090:

Line 2087: MSC_CL_COLLECTION.v_last_collection_id);

2083: MSC_CL_COLLECTION.v_is_partial_refresh,
2084: MSC_CL_COLLECTION.v_is_incremental_refresh,
2085: lv_tbl,
2086: MSC_CL_COLLECTION.v_current_user,
2087: MSC_CL_COLLECTION.v_last_collection_id);
2088:
2089: ELSIF (MSC_CL_COLLECTION.v_is_cont_refresh) THEN
2090:
2091: IF (MSC_CL_COLLECTION.v_coll_prec.supplier_response_flag = MSC_UTIL.SYS_YES and MSC_CL_COLLECTION.v_coll_prec.suprep_sn_flag = MSC_UTIL.SYS_INCR) THEN

Line 2089: ELSIF (MSC_CL_COLLECTION.v_is_cont_refresh) THEN

2085: lv_tbl,
2086: MSC_CL_COLLECTION.v_current_user,
2087: MSC_CL_COLLECTION.v_last_collection_id);
2088:
2089: ELSIF (MSC_CL_COLLECTION.v_is_cont_refresh) THEN
2090:
2091: IF (MSC_CL_COLLECTION.v_coll_prec.supplier_response_flag = MSC_UTIL.SYS_YES and MSC_CL_COLLECTION.v_coll_prec.suprep_sn_flag = MSC_UTIL.SYS_INCR) THEN
2092:
2093: MSC_CL_SUPPLIER_RESP.LOAD_SUPPLIER_RESPONSE

Line 2091: IF (MSC_CL_COLLECTION.v_coll_prec.supplier_response_flag = MSC_UTIL.SYS_YES and MSC_CL_COLLECTION.v_coll_prec.suprep_sn_flag = MSC_UTIL.SYS_INCR) THEN

2087: MSC_CL_COLLECTION.v_last_collection_id);
2088:
2089: ELSIF (MSC_CL_COLLECTION.v_is_cont_refresh) THEN
2090:
2091: IF (MSC_CL_COLLECTION.v_coll_prec.supplier_response_flag = MSC_UTIL.SYS_YES and MSC_CL_COLLECTION.v_coll_prec.suprep_sn_flag = MSC_UTIL.SYS_INCR) THEN
2092:
2093: MSC_CL_SUPPLIER_RESP.LOAD_SUPPLIER_RESPONSE
2094: ( MSC_CL_COLLECTION.v_instance_id,
2095: FALSE, --MSC_CL_COLLECTION.v_is_complete_refresh,

Line 2094: ( MSC_CL_COLLECTION.v_instance_id,

2090:
2091: IF (MSC_CL_COLLECTION.v_coll_prec.supplier_response_flag = MSC_UTIL.SYS_YES and MSC_CL_COLLECTION.v_coll_prec.suprep_sn_flag = MSC_UTIL.SYS_INCR) THEN
2092:
2093: MSC_CL_SUPPLIER_RESP.LOAD_SUPPLIER_RESPONSE
2094: ( MSC_CL_COLLECTION.v_instance_id,
2095: FALSE, --MSC_CL_COLLECTION.v_is_complete_refresh,
2096: FALSE, --MSC_CL_COLLECTION.v_is_partial_refresh,
2097: TRUE, --MSC_CL_COLLECTION.v_is_incremental_refresh,
2098: lv_tbl,

Line 2095: FALSE, --MSC_CL_COLLECTION.v_is_complete_refresh,

2091: IF (MSC_CL_COLLECTION.v_coll_prec.supplier_response_flag = MSC_UTIL.SYS_YES and MSC_CL_COLLECTION.v_coll_prec.suprep_sn_flag = MSC_UTIL.SYS_INCR) THEN
2092:
2093: MSC_CL_SUPPLIER_RESP.LOAD_SUPPLIER_RESPONSE
2094: ( MSC_CL_COLLECTION.v_instance_id,
2095: FALSE, --MSC_CL_COLLECTION.v_is_complete_refresh,
2096: FALSE, --MSC_CL_COLLECTION.v_is_partial_refresh,
2097: TRUE, --MSC_CL_COLLECTION.v_is_incremental_refresh,
2098: lv_tbl,
2099: MSC_CL_COLLECTION.v_current_user,

Line 2096: FALSE, --MSC_CL_COLLECTION.v_is_partial_refresh,

2092:
2093: MSC_CL_SUPPLIER_RESP.LOAD_SUPPLIER_RESPONSE
2094: ( MSC_CL_COLLECTION.v_instance_id,
2095: FALSE, --MSC_CL_COLLECTION.v_is_complete_refresh,
2096: FALSE, --MSC_CL_COLLECTION.v_is_partial_refresh,
2097: TRUE, --MSC_CL_COLLECTION.v_is_incremental_refresh,
2098: lv_tbl,
2099: MSC_CL_COLLECTION.v_current_user,
2100: MSC_CL_COLLECTION.v_last_collection_id);

Line 2097: TRUE, --MSC_CL_COLLECTION.v_is_incremental_refresh,

2093: MSC_CL_SUPPLIER_RESP.LOAD_SUPPLIER_RESPONSE
2094: ( MSC_CL_COLLECTION.v_instance_id,
2095: FALSE, --MSC_CL_COLLECTION.v_is_complete_refresh,
2096: FALSE, --MSC_CL_COLLECTION.v_is_partial_refresh,
2097: TRUE, --MSC_CL_COLLECTION.v_is_incremental_refresh,
2098: lv_tbl,
2099: MSC_CL_COLLECTION.v_current_user,
2100: MSC_CL_COLLECTION.v_last_collection_id);
2101:

Line 2099: MSC_CL_COLLECTION.v_current_user,

2095: FALSE, --MSC_CL_COLLECTION.v_is_complete_refresh,
2096: FALSE, --MSC_CL_COLLECTION.v_is_partial_refresh,
2097: TRUE, --MSC_CL_COLLECTION.v_is_incremental_refresh,
2098: lv_tbl,
2099: MSC_CL_COLLECTION.v_current_user,
2100: MSC_CL_COLLECTION.v_last_collection_id);
2101:
2102: END IF;
2103:

Line 2100: MSC_CL_COLLECTION.v_last_collection_id);

2096: FALSE, --MSC_CL_COLLECTION.v_is_partial_refresh,
2097: TRUE, --MSC_CL_COLLECTION.v_is_incremental_refresh,
2098: lv_tbl,
2099: MSC_CL_COLLECTION.v_current_user,
2100: MSC_CL_COLLECTION.v_last_collection_id);
2101:
2102: END IF;
2103:
2104: END IF; -- IF (v_is_complete_....

Line 2110: if MSC_CL_COLLECTION.v_is_cont_refresh then return; end if;

2106: END IF; --IF (G_MSC_CONFIGURA....
2107:
2108:
2109: -- agmcont
2110: if MSC_CL_COLLECTION.v_is_cont_refresh then return; end if;
2111:
2112: IF MSC_CL_COLLECTION.v_is_complete_refresh THEN
2113: COMMIT;
2114: END IF;

Line 2112: IF MSC_CL_COLLECTION.v_is_complete_refresh THEN

2108:
2109: -- agmcont
2110: if MSC_CL_COLLECTION.v_is_cont_refresh then return; end if;
2111:
2112: IF MSC_CL_COLLECTION.v_is_complete_refresh THEN
2113: COMMIT;
2114: END IF;
2115:
2116:

Line 2118: IF MSC_CL_COLLECTION.v_is_complete_refresh THEN

2114: END IF;
2115:
2116:
2117: /* analyze msc_supplies here */
2118: IF MSC_CL_COLLECTION.v_is_complete_refresh THEN
2119: IF MSC_CL_COLLECTION.v_exchange_mode= MSC_UTIL.SYS_YES THEN
2120: /* create temporay index */
2121: IF MSC_CL_SUPPLY_ODS_LOAD.create_supplies_tmp_ind THEN
2122: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Index creation on Temp Supplies table successful.');

Line 2119: IF MSC_CL_COLLECTION.v_exchange_mode= MSC_UTIL.SYS_YES THEN

2115:
2116:
2117: /* analyze msc_supplies here */
2118: IF MSC_CL_COLLECTION.v_is_complete_refresh THEN
2119: IF MSC_CL_COLLECTION.v_exchange_mode= MSC_UTIL.SYS_YES THEN
2120: /* create temporay index */
2121: IF MSC_CL_SUPPLY_ODS_LOAD.create_supplies_tmp_ind THEN
2122: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Index creation on Temp Supplies table successful.');
2123: ELSE

Line 2126: RAISE MSC_CL_COLLECTION.SUPPLIES_INDEX_FAIL;

2122: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Index creation on Temp Supplies table successful.');
2123: ELSE
2124: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2125: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Index creation on Temp Supplies table failed.');
2126: RAISE MSC_CL_COLLECTION.SUPPLIES_INDEX_FAIL;
2127: END IF;
2128: END IF;
2129: msc_analyse_tables_pk.analyse_table( lv_tbl, MSC_CL_COLLECTION.v_instance_id, -1);
2130: END IF;

Line 2129: msc_analyse_tables_pk.analyse_table( lv_tbl, MSC_CL_COLLECTION.v_instance_id, -1);

2125: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Index creation on Temp Supplies table failed.');
2126: RAISE MSC_CL_COLLECTION.SUPPLIES_INDEX_FAIL;
2127: END IF;
2128: END IF;
2129: msc_analyse_tables_pk.analyse_table( lv_tbl, MSC_CL_COLLECTION.v_instance_id, -1);
2130: END IF;
2131:
2132: EXCEPTION
2133:

Line 2134: WHEN MSC_CL_COLLECTION.SUPPLIES_INDEX_FAIL THEN

2130: END IF;
2131:
2132: EXCEPTION
2133:
2134: WHEN MSC_CL_COLLECTION.SUPPLIES_INDEX_FAIL THEN
2135:
2136: update msc_apps_instances
2137: set SUPPLIES_LOAD_FLAG = MSC_CL_COLLECTION.G_JOB_ERROR
2138: where instance_id = MSC_CL_COLLECTION.v_instance_id;

Line 2137: set SUPPLIES_LOAD_FLAG = MSC_CL_COLLECTION.G_JOB_ERROR

2133:
2134: WHEN MSC_CL_COLLECTION.SUPPLIES_INDEX_FAIL THEN
2135:
2136: update msc_apps_instances
2137: set SUPPLIES_LOAD_FLAG = MSC_CL_COLLECTION.G_JOB_ERROR
2138: where instance_id = MSC_CL_COLLECTION.v_instance_id;
2139: commit;
2140: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'MSC_CL_COLLECTION.SUPPLIES_INDEX_FAIL failed');
2141: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 2138: where instance_id = MSC_CL_COLLECTION.v_instance_id;

2134: WHEN MSC_CL_COLLECTION.SUPPLIES_INDEX_FAIL THEN
2135:
2136: update msc_apps_instances
2137: set SUPPLIES_LOAD_FLAG = MSC_CL_COLLECTION.G_JOB_ERROR
2138: where instance_id = MSC_CL_COLLECTION.v_instance_id;
2139: commit;
2140: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'MSC_CL_COLLECTION.SUPPLIES_INDEX_FAIL failed');
2141: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2142: RAISE;

Line 2140: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'MSC_CL_COLLECTION.SUPPLIES_INDEX_FAIL failed');

2136: update msc_apps_instances
2137: set SUPPLIES_LOAD_FLAG = MSC_CL_COLLECTION.G_JOB_ERROR
2138: where instance_id = MSC_CL_COLLECTION.v_instance_id;
2139: commit;
2140: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'MSC_CL_COLLECTION.SUPPLIES_INDEX_FAIL failed');
2141: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2142: RAISE;
2143:
2144: WHEN OTHERS THEN

Line 2147: set SUPPLIES_LOAD_FLAG = MSC_CL_COLLECTION.G_JOB_ERROR

2143:
2144: WHEN OTHERS THEN
2145:
2146: update msc_apps_instances
2147: set SUPPLIES_LOAD_FLAG = MSC_CL_COLLECTION.G_JOB_ERROR
2148: where instance_id = MSC_CL_COLLECTION.v_instance_id;
2149: commit;
2150:
2151: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'load supply other exception');

Line 2148: where instance_id = MSC_CL_COLLECTION.v_instance_id;

2144: WHEN OTHERS THEN
2145:
2146: update msc_apps_instances
2147: set SUPPLIES_LOAD_FLAG = MSC_CL_COLLECTION.G_JOB_ERROR
2148: where instance_id = MSC_CL_COLLECTION.v_instance_id;
2149: commit;
2150:
2151: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'load supply other exception');
2152: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 2321: MSC_CL_COLLECTION.NEED_BY_DATE_PREF, MSC_CALENDAR.DATE_OFFSET(x.ORGANIZATION_ID,

2317: x.UNIT_NUMBER,
2318: /* decode(x.ORDER_TYPE, 1,
2319: decode(lv_po_dock_date_ref,
2320: PROMISED_DATE_PREF , x.NEW_SCHEDULE_DATE,
2321: MSC_CL_COLLECTION.NEED_BY_DATE_PREF, MSC_CALENDAR.DATE_OFFSET(x.ORGANIZATION_ID,
2322: x.SR_INSTANCE_ID,
2323: TYPE_DAILY_BUCKET,
2324: (MSC_CALENDAR.NEXT_WORK_DAY
2325: (x.ORGANIZATION_ID,

Line 2384: MSC_CL_COLLECTION.PROMISED_DATE_PREF, nvl(x.PROMISED_DATE, x.NEED_BY_DATE),

2380: x.VOLUME_CAPACITY_USED,
2381: x.NEW_SHIP_DATE,
2382: /* CP-ACK starts */
2383: nvl(decode(lv_po_dock_date_ref,
2384: MSC_CL_COLLECTION.PROMISED_DATE_PREF, nvl(x.PROMISED_DATE, x.NEED_BY_DATE),
2385: MSC_CL_COLLECTION.NEED_BY_DATE_PREF , nvl(x.NEED_BY_DATE, x.PROMISED_DATE)
2386: ),new_dock_date) NEW_DOCK_DATE,
2387: /* CP-ACK ends */
2388: x.LINE_ID,

Line 2385: MSC_CL_COLLECTION.NEED_BY_DATE_PREF , nvl(x.NEED_BY_DATE, x.PROMISED_DATE)

2381: x.NEW_SHIP_DATE,
2382: /* CP-ACK starts */
2383: nvl(decode(lv_po_dock_date_ref,
2384: MSC_CL_COLLECTION.PROMISED_DATE_PREF, nvl(x.PROMISED_DATE, x.NEED_BY_DATE),
2385: MSC_CL_COLLECTION.NEED_BY_DATE_PREF , nvl(x.NEED_BY_DATE, x.PROMISED_DATE)
2386: ),new_dock_date) NEW_DOCK_DATE,
2387: /* CP-ACK ends */
2388: x.LINE_ID,
2389: x.PROJECT_ID,

Line 2394: REPLACE(REPLACE(x.ORDER_NUMBER,MSC_CL_COLLECTION.v_chr10),MSC_CL_COLLECTION.v_chr13) ORDER_NUMBER,

2390: x.TASK_ID,
2391: x.PLANNING_GROUP,
2392: x.NUMBER1,
2393: x.SOURCE_ITEM_ID,
2394: REPLACE(REPLACE(x.ORDER_NUMBER,MSC_CL_COLLECTION.v_chr10),MSC_CL_COLLECTION.v_chr13) ORDER_NUMBER,
2395: x.SCHEDULE_GROUP_ID,
2396: x.BUILD_SEQUENCE,
2397: REPLACE(REPLACE(x.WIP_ENTITY_NAME,MSC_CL_COLLECTION.v_chr10),MSC_CL_COLLECTION.v_chr13) WIP_ENTITY_NAME,
2398: x.IMPLEMENT_PROCESSING_DAYS,

Line 2397: REPLACE(REPLACE(x.WIP_ENTITY_NAME,MSC_CL_COLLECTION.v_chr10),MSC_CL_COLLECTION.v_chr13) WIP_ENTITY_NAME,

2393: x.SOURCE_ITEM_ID,
2394: REPLACE(REPLACE(x.ORDER_NUMBER,MSC_CL_COLLECTION.v_chr10),MSC_CL_COLLECTION.v_chr13) ORDER_NUMBER,
2395: x.SCHEDULE_GROUP_ID,
2396: x.BUILD_SEQUENCE,
2397: REPLACE(REPLACE(x.WIP_ENTITY_NAME,MSC_CL_COLLECTION.v_chr10),MSC_CL_COLLECTION.v_chr13) WIP_ENTITY_NAME,
2398: x.IMPLEMENT_PROCESSING_DAYS,
2399: x.DELIVERY_PRICE,
2400: x.LATE_SUPPLY_DATE,
2401: x.LATE_SUPPLY_QTY,

Line 2480: AND x.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id

2476: AND tps1.PARTNER_TYPE(+)= 1
2477: AND tps2.SR_TP_SITE_ID(+)= x.OWNING_PARTNER_SITE_ID
2478: AND tps2.SR_INSTANCE_ID(+)= x.SR_INSTANCE_ID
2479: AND tps2.PARTNER_TYPE(+)= 1
2480: AND x.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
2481: AND x.DELETED_FLAG= MSC_UTIL.SYS_NO
2482: AND md.SR_INSTANCE_ID(+)= x.SR_INSTANCE_ID
2483: AND md.DESIGNATOR(+)= x.SCHEDULE_DESIGNATOR
2484: AND md.Organization_ID(+)= x.Organization_ID

Line 2487: AND x.ORDER_TYPE NOT IN (MSC_CL_COLLECTION.G_MRP_PO_ACK)

2483: AND md.DESIGNATOR(+)= x.SCHEDULE_DESIGNATOR
2484: AND md.Organization_ID(+)= x.Organization_ID
2485: AND md.Designator_Type(+)= 2 -- MPS
2486: /* CP-ACK starts */
2487: AND x.ORDER_TYPE NOT IN (MSC_CL_COLLECTION.G_MRP_PO_ACK)
2488: /* CP-ACK ends */
2489: order by x.Organization_ID;
2490:
2491:

Line 2496: WHERE x.SR_INSTANCE_ID = MSC_CL_COLLECTION.v_instance_id

2492: /* PREPLACE START */ -- Could this be performance intensive
2493: CURSOR c2 IS
2494: SELECT x.INVENTORY_ITEM_ID
2495: FROM MSC_ST_SUPPLIES x
2496: WHERE x.SR_INSTANCE_ID = MSC_CL_COLLECTION.v_instance_id
2497: MINUS
2498: SELECT SR_INVENTORY_ITEM_ID INVENTORY_ITEM_ID
2499: FROM MSC_ITEM_ID_LID
2500: WHERE SR_INSTANCE_ID = MSC_CL_COLLECTION.v_instance_id;

Line 2500: WHERE SR_INSTANCE_ID = MSC_CL_COLLECTION.v_instance_id;

2496: WHERE x.SR_INSTANCE_ID = MSC_CL_COLLECTION.v_instance_id
2497: MINUS
2498: SELECT SR_INVENTORY_ITEM_ID INVENTORY_ITEM_ID
2499: FROM MSC_ITEM_ID_LID
2500: WHERE SR_INSTANCE_ID = MSC_CL_COLLECTION.v_instance_id;
2501:
2502: c_count NUMBER;
2503:
2504: BEGIN

Line 2508: lv_po_dock_date_ref := nvl(fnd_profile.value('MSC_PO_DOCK_DATE_CALC_PREF'), MSC_CL_COLLECTION.PROMISED_DATE_PREF);

2504: BEGIN
2505:
2506:
2507: /* CP-ACK starts */
2508: lv_po_dock_date_ref := nvl(fnd_profile.value('MSC_PO_DOCK_DATE_CALC_PREF'), MSC_CL_COLLECTION.PROMISED_DATE_PREF);
2509: /* CP-ACk ends */
2510:
2511: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'load_staging_supply');
2512:

Line 2514: lv_temp_supply_tbl := 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;

2510:
2511: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'load_staging_supply');
2512:
2513:
2514: lv_temp_supply_tbl := 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
2515: c_count := 0;
2516:
2517: lv_sql_stmt :=
2518: 'INSERT INTO ' || lv_temp_supply_tbl

Line 2781: if (MSC_CL_COLLECTION.v_is_cont_refresh = FALSE) then

2777:
2778: -- MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The sql statement is '||lv_sql_stmt);
2779:
2780: --agmcont:
2781: if (MSC_CL_COLLECTION.v_is_cont_refresh = FALSE) then
2782:
2783: FOR c_rec IN c1 LOOP
2784: -- MSC_CL_COLLECTION.log_debug('in calendar loop ');
2785:

Line 2784: -- MSC_CL_COLLECTION.log_debug('in calendar loop ');

2780: --agmcont:
2781: if (MSC_CL_COLLECTION.v_is_cont_refresh = FALSE) then
2782:
2783: FOR c_rec IN c1 LOOP
2784: -- MSC_CL_COLLECTION.log_debug('in calendar loop ');
2785:
2786: BEGIN
2787:
2788: --logic for calculating dock date and schedule date

Line 2993: MSC_CL_COLLECTION.v_last_collection_id,

2989: c_rec.VMI_FLAG ,
2990: c_rec.PO_LINE_LOCATION_ID,
2991: c_rec.PO_DISTRIBUTION_ID,
2992: c_rec.SR_MTL_SUPPLY_ID,
2993: MSC_CL_COLLECTION.v_last_collection_id,
2994: MSC_CL_COLLECTION.v_current_date,
2995: MSC_CL_COLLECTION.v_current_user,
2996: MSC_CL_COLLECTION.v_current_date,
2997: MSC_CL_COLLECTION.v_current_user,

Line 2994: MSC_CL_COLLECTION.v_current_date,

2990: c_rec.PO_LINE_LOCATION_ID,
2991: c_rec.PO_DISTRIBUTION_ID,
2992: c_rec.SR_MTL_SUPPLY_ID,
2993: MSC_CL_COLLECTION.v_last_collection_id,
2994: MSC_CL_COLLECTION.v_current_date,
2995: MSC_CL_COLLECTION.v_current_user,
2996: MSC_CL_COLLECTION.v_current_date,
2997: MSC_CL_COLLECTION.v_current_user,
2998: /* CP-ACK starts */

Line 2995: MSC_CL_COLLECTION.v_current_user,

2991: c_rec.PO_DISTRIBUTION_ID,
2992: c_rec.SR_MTL_SUPPLY_ID,
2993: MSC_CL_COLLECTION.v_last_collection_id,
2994: MSC_CL_COLLECTION.v_current_date,
2995: MSC_CL_COLLECTION.v_current_user,
2996: MSC_CL_COLLECTION.v_current_date,
2997: MSC_CL_COLLECTION.v_current_user,
2998: /* CP-ACK starts */
2999: c_rec.ORIGINAL_NEED_BY_DATE,

Line 2996: MSC_CL_COLLECTION.v_current_date,

2992: c_rec.SR_MTL_SUPPLY_ID,
2993: MSC_CL_COLLECTION.v_last_collection_id,
2994: MSC_CL_COLLECTION.v_current_date,
2995: MSC_CL_COLLECTION.v_current_user,
2996: MSC_CL_COLLECTION.v_current_date,
2997: MSC_CL_COLLECTION.v_current_user,
2998: /* CP-ACK starts */
2999: c_rec.ORIGINAL_NEED_BY_DATE,
3000: c_rec.ORIGINAL_QUANTITY,

Line 2997: MSC_CL_COLLECTION.v_current_user,

2993: MSC_CL_COLLECTION.v_last_collection_id,
2994: MSC_CL_COLLECTION.v_current_date,
2995: MSC_CL_COLLECTION.v_current_user,
2996: MSC_CL_COLLECTION.v_current_date,
2997: MSC_CL_COLLECTION.v_current_user,
2998: /* CP-ACK starts */
2999: c_rec.ORIGINAL_NEED_BY_DATE,
3000: c_rec.ORIGINAL_QUANTITY,
3001: c_rec.PROMISED_DATE,

Line 3033: IF c_count> MSC_CL_COLLECTION.PBS THEN

3029: --END IF;
3030:
3031: c_count:= c_count+1;
3032:
3033: IF c_count> MSC_CL_COLLECTION.PBS THEN
3034: COMMIT;
3035: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The total record count inserted is '||TO_CHAR(c_count));
3036: c_count:= 0;
3037: END IF;

Line 3051: set SUPPLIES_LOAD_FLAG = MSC_CL_COLLECTION.G_JOB_ERROR

3047: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
3048: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3049:
3050: update msc_apps_instances
3051: set SUPPLIES_LOAD_FLAG = MSC_CL_COLLECTION.G_JOB_ERROR
3052: where instance_id = MSC_CL_COLLECTION.v_instance_id;
3053: commit;
3054:
3055: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 3052: where instance_id = MSC_CL_COLLECTION.v_instance_id;

3048: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3049:
3050: update msc_apps_instances
3051: set SUPPLIES_LOAD_FLAG = MSC_CL_COLLECTION.G_JOB_ERROR
3052: where instance_id = MSC_CL_COLLECTION.v_instance_id;
3053: commit;
3054:
3055: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3056: RAISE;

Line 3059: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

3055: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3056: RAISE;
3057:
3058: ELSE
3059: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3060:
3061: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'E========================================');
3062: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3063: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_STAGING_SUPPLY');

Line 3076: MSC_CL_COLLECTION.v_instance_id));

3072: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3073: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3074: FND_MESSAGE.SET_TOKEN('VALUE',
3075: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3076: MSC_CL_COLLECTION.v_instance_id));
3077: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3078:
3079: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3080: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORDER_TYPE');

Line 3113: IF (MSC_CL_COLLECTION.v_coll_prec.supplier_response_flag = MSC_UTIL.SYS_YES) THEN

3109: IF ( MSC_UTIL.G_MSC_CONFIGURATION = MSC_UTIL.G_CONF_APS_SCE
3110: OR MSC_UTIL.G_MSC_CONFIGURATION = MSC_UTIL.G_CONF_SCE
3111: ) THEN
3112:
3113: IF (MSC_CL_COLLECTION.v_coll_prec.supplier_response_flag = MSC_UTIL.SYS_YES) THEN
3114:
3115: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Loading Supplier Responses from iSupplier Portal');
3116:
3117: MSC_CL_SUPPLIER_RESP.LOAD_SUPPLIER_RESPONSE

Line 3118: ( MSC_CL_COLLECTION.v_instance_id,

3114:
3115: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Loading Supplier Responses from iSupplier Portal');
3116:
3117: MSC_CL_SUPPLIER_RESP.LOAD_SUPPLIER_RESPONSE
3118: ( MSC_CL_COLLECTION.v_instance_id,
3119: MSC_CL_COLLECTION.v_is_complete_refresh,
3120: MSC_CL_COLLECTION.v_is_partial_refresh,
3121: MSC_CL_COLLECTION.v_is_incremental_refresh,
3122: lv_temp_supply_tbl,

Line 3119: MSC_CL_COLLECTION.v_is_complete_refresh,

3115: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Loading Supplier Responses from iSupplier Portal');
3116:
3117: MSC_CL_SUPPLIER_RESP.LOAD_SUPPLIER_RESPONSE
3118: ( MSC_CL_COLLECTION.v_instance_id,
3119: MSC_CL_COLLECTION.v_is_complete_refresh,
3120: MSC_CL_COLLECTION.v_is_partial_refresh,
3121: MSC_CL_COLLECTION.v_is_incremental_refresh,
3122: lv_temp_supply_tbl,
3123: MSC_CL_COLLECTION.v_current_user,

Line 3120: MSC_CL_COLLECTION.v_is_partial_refresh,

3116:
3117: MSC_CL_SUPPLIER_RESP.LOAD_SUPPLIER_RESPONSE
3118: ( MSC_CL_COLLECTION.v_instance_id,
3119: MSC_CL_COLLECTION.v_is_complete_refresh,
3120: MSC_CL_COLLECTION.v_is_partial_refresh,
3121: MSC_CL_COLLECTION.v_is_incremental_refresh,
3122: lv_temp_supply_tbl,
3123: MSC_CL_COLLECTION.v_current_user,
3124: MSC_CL_COLLECTION.v_last_collection_id);

Line 3121: MSC_CL_COLLECTION.v_is_incremental_refresh,

3117: MSC_CL_SUPPLIER_RESP.LOAD_SUPPLIER_RESPONSE
3118: ( MSC_CL_COLLECTION.v_instance_id,
3119: MSC_CL_COLLECTION.v_is_complete_refresh,
3120: MSC_CL_COLLECTION.v_is_partial_refresh,
3121: MSC_CL_COLLECTION.v_is_incremental_refresh,
3122: lv_temp_supply_tbl,
3123: MSC_CL_COLLECTION.v_current_user,
3124: MSC_CL_COLLECTION.v_last_collection_id);
3125:

Line 3123: MSC_CL_COLLECTION.v_current_user,

3119: MSC_CL_COLLECTION.v_is_complete_refresh,
3120: MSC_CL_COLLECTION.v_is_partial_refresh,
3121: MSC_CL_COLLECTION.v_is_incremental_refresh,
3122: lv_temp_supply_tbl,
3123: MSC_CL_COLLECTION.v_current_user,
3124: MSC_CL_COLLECTION.v_last_collection_id);
3125:
3126: END IF;
3127:

Line 3124: MSC_CL_COLLECTION.v_last_collection_id);

3120: MSC_CL_COLLECTION.v_is_partial_refresh,
3121: MSC_CL_COLLECTION.v_is_incremental_refresh,
3122: lv_temp_supply_tbl,
3123: MSC_CL_COLLECTION.v_current_user,
3124: MSC_CL_COLLECTION.v_last_collection_id);
3125:
3126: END IF;
3127:
3128: END IF;

Line 3147: IF ((MSC_CL_COLLECTION.v_coll_prec.mps_flag = MSC_UTIL.SYS_YES and MSC_CL_COLLECTION.v_coll_prec.mps_sn_flag = MSC_UTIL.SYS_TGT) OR

3143: targeted basis then we need not to execute lv_cur_sql_stmt because there
3144: is seperate API to take care of Supplier Responses. */
3145:
3146:
3147: IF ((MSC_CL_COLLECTION.v_coll_prec.mps_flag = MSC_UTIL.SYS_YES and MSC_CL_COLLECTION.v_coll_prec.mps_sn_flag = MSC_UTIL.SYS_TGT) OR
3148: (MSC_CL_COLLECTION.v_coll_prec.wip_flag = MSC_UTIL.SYS_YES and MSC_CL_COLLECTION.v_coll_prec.wip_sn_flag = MSC_UTIL.SYS_TGT) OR
3149: (MSC_CL_COLLECTION.v_coll_prec.po_flag = MSC_UTIL.SYS_YES and MSC_CL_COLLECTION.v_coll_prec.po_sn_flag = MSC_UTIL.SYS_TGT) OR
3150: (MSC_CL_COLLECTION.v_coll_prec.oh_flag = MSC_UTIL.SYS_YES and MSC_CL_COLLECTION.v_coll_prec.oh_sn_flag = MSC_UTIL.SYS_TGT) OR
3151: (MSC_CL_COLLECTION.v_coll_prec.user_supply_demand_flag = MSC_UTIL.SYS_YES and MSC_CL_COLLECTION.v_coll_prec.usup_sn_flag = MSC_UTIL.SYS_TGT)

Line 3148: (MSC_CL_COLLECTION.v_coll_prec.wip_flag = MSC_UTIL.SYS_YES and MSC_CL_COLLECTION.v_coll_prec.wip_sn_flag = MSC_UTIL.SYS_TGT) OR

3144: is seperate API to take care of Supplier Responses. */
3145:
3146:
3147: IF ((MSC_CL_COLLECTION.v_coll_prec.mps_flag = MSC_UTIL.SYS_YES and MSC_CL_COLLECTION.v_coll_prec.mps_sn_flag = MSC_UTIL.SYS_TGT) OR
3148: (MSC_CL_COLLECTION.v_coll_prec.wip_flag = MSC_UTIL.SYS_YES and MSC_CL_COLLECTION.v_coll_prec.wip_sn_flag = MSC_UTIL.SYS_TGT) OR
3149: (MSC_CL_COLLECTION.v_coll_prec.po_flag = MSC_UTIL.SYS_YES and MSC_CL_COLLECTION.v_coll_prec.po_sn_flag = MSC_UTIL.SYS_TGT) OR
3150: (MSC_CL_COLLECTION.v_coll_prec.oh_flag = MSC_UTIL.SYS_YES and MSC_CL_COLLECTION.v_coll_prec.oh_sn_flag = MSC_UTIL.SYS_TGT) OR
3151: (MSC_CL_COLLECTION.v_coll_prec.user_supply_demand_flag = MSC_UTIL.SYS_YES and MSC_CL_COLLECTION.v_coll_prec.usup_sn_flag = MSC_UTIL.SYS_TGT)
3152: ) THEN

Line 3149: (MSC_CL_COLLECTION.v_coll_prec.po_flag = MSC_UTIL.SYS_YES and MSC_CL_COLLECTION.v_coll_prec.po_sn_flag = MSC_UTIL.SYS_TGT) OR

3145:
3146:
3147: IF ((MSC_CL_COLLECTION.v_coll_prec.mps_flag = MSC_UTIL.SYS_YES and MSC_CL_COLLECTION.v_coll_prec.mps_sn_flag = MSC_UTIL.SYS_TGT) OR
3148: (MSC_CL_COLLECTION.v_coll_prec.wip_flag = MSC_UTIL.SYS_YES and MSC_CL_COLLECTION.v_coll_prec.wip_sn_flag = MSC_UTIL.SYS_TGT) OR
3149: (MSC_CL_COLLECTION.v_coll_prec.po_flag = MSC_UTIL.SYS_YES and MSC_CL_COLLECTION.v_coll_prec.po_sn_flag = MSC_UTIL.SYS_TGT) OR
3150: (MSC_CL_COLLECTION.v_coll_prec.oh_flag = MSC_UTIL.SYS_YES and MSC_CL_COLLECTION.v_coll_prec.oh_sn_flag = MSC_UTIL.SYS_TGT) OR
3151: (MSC_CL_COLLECTION.v_coll_prec.user_supply_demand_flag = MSC_UTIL.SYS_YES and MSC_CL_COLLECTION.v_coll_prec.usup_sn_flag = MSC_UTIL.SYS_TGT)
3152: ) THEN
3153:

Line 3150: (MSC_CL_COLLECTION.v_coll_prec.oh_flag = MSC_UTIL.SYS_YES and MSC_CL_COLLECTION.v_coll_prec.oh_sn_flag = MSC_UTIL.SYS_TGT) OR

3146:
3147: IF ((MSC_CL_COLLECTION.v_coll_prec.mps_flag = MSC_UTIL.SYS_YES and MSC_CL_COLLECTION.v_coll_prec.mps_sn_flag = MSC_UTIL.SYS_TGT) OR
3148: (MSC_CL_COLLECTION.v_coll_prec.wip_flag = MSC_UTIL.SYS_YES and MSC_CL_COLLECTION.v_coll_prec.wip_sn_flag = MSC_UTIL.SYS_TGT) OR
3149: (MSC_CL_COLLECTION.v_coll_prec.po_flag = MSC_UTIL.SYS_YES and MSC_CL_COLLECTION.v_coll_prec.po_sn_flag = MSC_UTIL.SYS_TGT) OR
3150: (MSC_CL_COLLECTION.v_coll_prec.oh_flag = MSC_UTIL.SYS_YES and MSC_CL_COLLECTION.v_coll_prec.oh_sn_flag = MSC_UTIL.SYS_TGT) OR
3151: (MSC_CL_COLLECTION.v_coll_prec.user_supply_demand_flag = MSC_UTIL.SYS_YES and MSC_CL_COLLECTION.v_coll_prec.usup_sn_flag = MSC_UTIL.SYS_TGT)
3152: ) THEN
3153:
3154: lv_cur_sql_stmt :=

Line 3151: (MSC_CL_COLLECTION.v_coll_prec.user_supply_demand_flag = MSC_UTIL.SYS_YES and MSC_CL_COLLECTION.v_coll_prec.usup_sn_flag = MSC_UTIL.SYS_TGT)

3147: IF ((MSC_CL_COLLECTION.v_coll_prec.mps_flag = MSC_UTIL.SYS_YES and MSC_CL_COLLECTION.v_coll_prec.mps_sn_flag = MSC_UTIL.SYS_TGT) OR
3148: (MSC_CL_COLLECTION.v_coll_prec.wip_flag = MSC_UTIL.SYS_YES and MSC_CL_COLLECTION.v_coll_prec.wip_sn_flag = MSC_UTIL.SYS_TGT) OR
3149: (MSC_CL_COLLECTION.v_coll_prec.po_flag = MSC_UTIL.SYS_YES and MSC_CL_COLLECTION.v_coll_prec.po_sn_flag = MSC_UTIL.SYS_TGT) OR
3150: (MSC_CL_COLLECTION.v_coll_prec.oh_flag = MSC_UTIL.SYS_YES and MSC_CL_COLLECTION.v_coll_prec.oh_sn_flag = MSC_UTIL.SYS_TGT) OR
3151: (MSC_CL_COLLECTION.v_coll_prec.user_supply_demand_flag = MSC_UTIL.SYS_YES and MSC_CL_COLLECTION.v_coll_prec.usup_sn_flag = MSC_UTIL.SYS_TGT)
3152: ) THEN
3153:
3154: lv_cur_sql_stmt :=
3155: 'SELECT'

Line 3167: || MSC_CL_COLLECTION.NEED_BY_DATE_PREF ||', MSC_CALENDAR.DATE_OFFSET(x.ORGANIZATION_ID,'

3163: || ' x.UNIT_NUMBER,'
3164: /*|| ' decode(x.ORDER_TYPE, 1,'
3165: || ' decode( '||lv_po_dock_date_ref|| ' ,'
3166: || PROMISED_DATE_PREF ||', x.NEW_SCHEDULE_DATE,'
3167: || MSC_CL_COLLECTION.NEED_BY_DATE_PREF ||', MSC_CALENDAR.DATE_OFFSET(x.ORGANIZATION_ID,'
3168: || ' x.SR_INSTANCE_ID,'
3169: || TYPE_DAILY_BUCKET ||' ,'
3170: || ' (MSC_CALENDAR.NEXT_WORK_DAY'
3171: || ' (x.ORGANIZATION_ID,'

Line 3230: || MSC_CL_COLLECTION.PROMISED_DATE_PREF ||' , nvl(x.PROMISED_DATE, x.NEED_BY_DATE), '

3226: || ' x.VOLUME_CAPACITY_USED,'
3227: || ' x.NEW_SHIP_DATE,'
3228: /* CP-ACK starts */
3229: || ' nvl(decode( '||lv_po_dock_date_ref ||', '
3230: || MSC_CL_COLLECTION.PROMISED_DATE_PREF ||' , nvl(x.PROMISED_DATE, x.NEED_BY_DATE), '
3231: || MSC_CL_COLLECTION.NEED_BY_DATE_PREF ||' , nvl(x.NEED_BY_DATE, x.PROMISED_DATE) '
3232: || ' ),new_dock_date) NEW_DOCK_DATE, '
3233: /* CP-ACK ends */
3234: -- || ' x.NEW_DOCK_DATE,'

Line 3231: || MSC_CL_COLLECTION.NEED_BY_DATE_PREF ||' , nvl(x.NEED_BY_DATE, x.PROMISED_DATE) '

3227: || ' x.NEW_SHIP_DATE,'
3228: /* CP-ACK starts */
3229: || ' nvl(decode( '||lv_po_dock_date_ref ||', '
3230: || MSC_CL_COLLECTION.PROMISED_DATE_PREF ||' , nvl(x.PROMISED_DATE, x.NEED_BY_DATE), '
3231: || MSC_CL_COLLECTION.NEED_BY_DATE_PREF ||' , nvl(x.NEED_BY_DATE, x.PROMISED_DATE) '
3232: || ' ),new_dock_date) NEW_DOCK_DATE, '
3233: /* CP-ACK ends */
3234: -- || ' x.NEW_DOCK_DATE,'
3235: || ' x.LINE_ID,'

Line 3326: || ' AND x.SR_INSTANCE_ID=' || MSC_CL_COLLECTION.v_instance_id

3322: || ' AND tps1.PARTNER_TYPE(+)= 1'
3323: || ' AND tps2.SR_TP_SITE_ID(+)= x.OWNING_PARTNER_SITE_ID'
3324: || ' AND tps2.SR_INSTANCE_ID(+)= x.SR_INSTANCE_ID'
3325: || ' AND tps2.PARTNER_TYPE(+)= 1'
3326: || ' AND x.SR_INSTANCE_ID=' || MSC_CL_COLLECTION.v_instance_id
3327: || ' AND x.DELETED_FLAG=' || MSC_UTIL.SYS_NO
3328: || ' AND md.SR_INSTANCE_ID(+)= x.SR_INSTANCE_ID'
3329: || ' AND md.DESIGNATOR(+)= x.SCHEDULE_DESIGNATOR'
3330: || ' AND md.Organization_ID(+)= x.Organization_ID'

Line 3338: if (MSC_CL_COLLECTION.v_coll_prec.mps_flag = MSC_UTIL.SYS_YES) and

3334:
3335:
3336: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'load_staging_supply: 5');
3337:
3338: if (MSC_CL_COLLECTION.v_coll_prec.mps_flag = MSC_UTIL.SYS_YES) and
3339: (MSC_CL_COLLECTION.v_coll_prec.mps_sn_flag = MSC_UTIL.SYS_TGT) then
3340: lv_where_clause := '5';
3341: end if;
3342:

Line 3339: (MSC_CL_COLLECTION.v_coll_prec.mps_sn_flag = MSC_UTIL.SYS_TGT) then

3335:
3336: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'load_staging_supply: 5');
3337:
3338: if (MSC_CL_COLLECTION.v_coll_prec.mps_flag = MSC_UTIL.SYS_YES) and
3339: (MSC_CL_COLLECTION.v_coll_prec.mps_sn_flag = MSC_UTIL.SYS_TGT) then
3340: lv_where_clause := '5';
3341: end if;
3342:
3343: if (MSC_CL_COLLECTION.v_coll_prec.wip_flag = MSC_UTIL.SYS_YES) and

Line 3343: if (MSC_CL_COLLECTION.v_coll_prec.wip_flag = MSC_UTIL.SYS_YES) and

3339: (MSC_CL_COLLECTION.v_coll_prec.mps_sn_flag = MSC_UTIL.SYS_TGT) then
3340: lv_where_clause := '5';
3341: end if;
3342:
3343: if (MSC_CL_COLLECTION.v_coll_prec.wip_flag = MSC_UTIL.SYS_YES) and
3344: (MSC_CL_COLLECTION.v_coll_prec.wip_sn_flag = MSC_UTIL.SYS_TGT) then
3345: if (lv_where_clause is null) then
3346: lv_where_clause := '3,7,14,15,16,27,30,70';
3347: else

Line 3344: (MSC_CL_COLLECTION.v_coll_prec.wip_sn_flag = MSC_UTIL.SYS_TGT) then

3340: lv_where_clause := '5';
3341: end if;
3342:
3343: if (MSC_CL_COLLECTION.v_coll_prec.wip_flag = MSC_UTIL.SYS_YES) and
3344: (MSC_CL_COLLECTION.v_coll_prec.wip_sn_flag = MSC_UTIL.SYS_TGT) then
3345: if (lv_where_clause is null) then
3346: lv_where_clause := '3,7,14,15,16,27,30,70';
3347: else
3348: lv_where_clause := lv_where_clause||',3,7,14,15,16,27,30,70';

Line 3352: if (MSC_CL_COLLECTION.v_coll_prec.po_flag = MSC_UTIL.SYS_YES) and

3348: lv_where_clause := lv_where_clause||',3,7,14,15,16,27,30,70';
3349: end if;
3350: end if;
3351:
3352: if (MSC_CL_COLLECTION.v_coll_prec.po_flag = MSC_UTIL.SYS_YES) and
3353: (MSC_CL_COLLECTION.v_coll_prec.po_sn_flag = MSC_UTIL.SYS_TGT) then
3354: if (lv_where_clause is null) then
3355: lv_where_clause := '1,2,8,11,12,73,74,87';
3356: else

Line 3353: (MSC_CL_COLLECTION.v_coll_prec.po_sn_flag = MSC_UTIL.SYS_TGT) then

3349: end if;
3350: end if;
3351:
3352: if (MSC_CL_COLLECTION.v_coll_prec.po_flag = MSC_UTIL.SYS_YES) and
3353: (MSC_CL_COLLECTION.v_coll_prec.po_sn_flag = MSC_UTIL.SYS_TGT) then
3354: if (lv_where_clause is null) then
3355: lv_where_clause := '1,2,8,11,12,73,74,87';
3356: else
3357: lv_where_clause := lv_where_clause||',1,2,8,11,12,73,74,87';

Line 3361: if (MSC_CL_COLLECTION.v_coll_prec.oh_flag = MSC_UTIL.SYS_YES) and

3357: lv_where_clause := lv_where_clause||',1,2,8,11,12,73,74,87';
3358: end if;
3359: end if;
3360:
3361: if (MSC_CL_COLLECTION.v_coll_prec.oh_flag = MSC_UTIL.SYS_YES) and
3362: (MSC_CL_COLLECTION.v_coll_prec.oh_sn_flag = MSC_UTIL.SYS_TGT) then
3363: if (lv_where_clause is null) then
3364: lv_where_clause := '18';
3365: else

Line 3362: (MSC_CL_COLLECTION.v_coll_prec.oh_sn_flag = MSC_UTIL.SYS_TGT) then

3358: end if;
3359: end if;
3360:
3361: if (MSC_CL_COLLECTION.v_coll_prec.oh_flag = MSC_UTIL.SYS_YES) and
3362: (MSC_CL_COLLECTION.v_coll_prec.oh_sn_flag = MSC_UTIL.SYS_TGT) then
3363: if (lv_where_clause is null) then
3364: lv_where_clause := '18';
3365: else
3366: lv_where_clause := lv_where_clause||',18';

Line 3370: if (MSC_CL_COLLECTION.v_coll_prec.user_supply_demand_flag = MSC_UTIL.SYS_YES) and

3366: lv_where_clause := lv_where_clause||',18';
3367: end if;
3368: end if;
3369:
3370: if (MSC_CL_COLLECTION.v_coll_prec.user_supply_demand_flag = MSC_UTIL.SYS_YES) and
3371: (MSC_CL_COLLECTION.v_coll_prec.usup_sn_flag = MSC_UTIL.SYS_TGT) then
3372: if (lv_where_clause is null) then
3373: lv_where_clause := '41';
3374: else

Line 3371: (MSC_CL_COLLECTION.v_coll_prec.usup_sn_flag = MSC_UTIL.SYS_TGT) then

3367: end if;
3368: end if;
3369:
3370: if (MSC_CL_COLLECTION.v_coll_prec.user_supply_demand_flag = MSC_UTIL.SYS_YES) and
3371: (MSC_CL_COLLECTION.v_coll_prec.usup_sn_flag = MSC_UTIL.SYS_TGT) then
3372: if (lv_where_clause is null) then
3373: lv_where_clause := '41';
3374: else
3375: lv_where_clause := lv_where_clause||',41';

Line 3387: open cur for lv_cur_sql_stmt USING MSC_CL_COLLECTION.v_chr10, MSC_CL_COLLECTION.v_chr13, MSC_CL_COLLECTION.v_chr10, MSC_CL_COLLECTION.v_chr13;

3383: lv_cur_sql_stmt:=lv_cur_sql_stmt|| ' order by x.ORGANIZATION_ID ';
3384:
3385: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'lv_cur_sql_stmt=' || lv_cur_sql_stmt);
3386:
3387: open cur for lv_cur_sql_stmt USING MSC_CL_COLLECTION.v_chr10, MSC_CL_COLLECTION.v_chr13, MSC_CL_COLLECTION.v_chr10, MSC_CL_COLLECTION.v_chr13;
3388:
3389: LOOP
3390:
3391: fetch cur into

Line 3686: MSC_CL_COLLECTION.v_last_collection_id,

3682: lv_VMI_FLAG ,
3683: lv_PO_LINE_LOCATION_ID,
3684: lv_PO_DISTRIBUTION_ID,
3685: lv_SR_MTL_SUPPLY_ID,
3686: MSC_CL_COLLECTION.v_last_collection_id,
3687: MSC_CL_COLLECTION.v_current_date,
3688: MSC_CL_COLLECTION.v_current_user,
3689: MSC_CL_COLLECTION.v_current_date,
3690: MSC_CL_COLLECTION.v_current_user,

Line 3687: MSC_CL_COLLECTION.v_current_date,

3683: lv_PO_LINE_LOCATION_ID,
3684: lv_PO_DISTRIBUTION_ID,
3685: lv_SR_MTL_SUPPLY_ID,
3686: MSC_CL_COLLECTION.v_last_collection_id,
3687: MSC_CL_COLLECTION.v_current_date,
3688: MSC_CL_COLLECTION.v_current_user,
3689: MSC_CL_COLLECTION.v_current_date,
3690: MSC_CL_COLLECTION.v_current_user,
3691: /* CP-ACK starts */

Line 3688: MSC_CL_COLLECTION.v_current_user,

3684: lv_PO_DISTRIBUTION_ID,
3685: lv_SR_MTL_SUPPLY_ID,
3686: MSC_CL_COLLECTION.v_last_collection_id,
3687: MSC_CL_COLLECTION.v_current_date,
3688: MSC_CL_COLLECTION.v_current_user,
3689: MSC_CL_COLLECTION.v_current_date,
3690: MSC_CL_COLLECTION.v_current_user,
3691: /* CP-ACK starts */
3692: lv_original_need_by_date,

Line 3689: MSC_CL_COLLECTION.v_current_date,

3685: lv_SR_MTL_SUPPLY_ID,
3686: MSC_CL_COLLECTION.v_last_collection_id,
3687: MSC_CL_COLLECTION.v_current_date,
3688: MSC_CL_COLLECTION.v_current_user,
3689: MSC_CL_COLLECTION.v_current_date,
3690: MSC_CL_COLLECTION.v_current_user,
3691: /* CP-ACK starts */
3692: lv_original_need_by_date,
3693: lv_original_quantity,

Line 3690: MSC_CL_COLLECTION.v_current_user,

3686: MSC_CL_COLLECTION.v_last_collection_id,
3687: MSC_CL_COLLECTION.v_current_date,
3688: MSC_CL_COLLECTION.v_current_user,
3689: MSC_CL_COLLECTION.v_current_date,
3690: MSC_CL_COLLECTION.v_current_user,
3691: /* CP-ACK starts */
3692: lv_original_need_by_date,
3693: lv_original_quantity,
3694: lv_promised_date,

Line 3723: IF c_count> MSC_CL_COLLECTION.PBS THEN

3719: --END IF;
3720:
3721: c_count:= c_count+1;
3722:
3723: IF c_count> MSC_CL_COLLECTION.PBS THEN
3724: COMMIT;
3725: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The total record count inserted is '||TO_CHAR(c_count));
3726: c_count:= 0;
3727: END IF;

Line 3742: set SUPPLIES_LOAD_FLAG = MSC_CL_COLLECTION.G_JOB_ERROR

3738: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
3739: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3740:
3741: update msc_apps_instances
3742: set SUPPLIES_LOAD_FLAG = MSC_CL_COLLECTION.G_JOB_ERROR
3743: where instance_id = MSC_CL_COLLECTION.v_instance_id;
3744: commit;
3745:
3746: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 3743: where instance_id = MSC_CL_COLLECTION.v_instance_id;

3739: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3740:
3741: update msc_apps_instances
3742: set SUPPLIES_LOAD_FLAG = MSC_CL_COLLECTION.G_JOB_ERROR
3743: where instance_id = MSC_CL_COLLECTION.v_instance_id;
3744: commit;
3745:
3746: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3747: RAISE;

Line 3750: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

3746: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3747: RAISE;
3748:
3749: ELSE
3750: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3751:
3752: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3753: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3754: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');

Line 3759: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_COLLECTION.ITEM_NAME');

3755: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
3756: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3757:
3758: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3759: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_COLLECTION.ITEM_NAME');
3760: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( lv_INVENTORY_ITEM_ID));
3761: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3762:
3763: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 3767: MSC_CL_COLLECTION.v_instance_id));

3763: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3764: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3765: FND_MESSAGE.SET_TOKEN('VALUE',
3766: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
3767: MSC_CL_COLLECTION.v_instance_id));
3768: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3769:
3770: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3771: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORDER_TYPE');

Line 3797: END IF; -- IF ((MSC_CL_COLLECTION.v_coll_prec.mps_flag = SYS_YES and.....................

3793: */
3794:
3795: /* CP-AUTO */
3796:
3797: END IF; -- IF ((MSC_CL_COLLECTION.v_coll_prec.mps_flag = SYS_YES and.....................
3798: /* CP-AUTO starts */
3799: --===================================================
3800: -- Call the API to load PO Supplier responses in
3801: -- msc_supplies. The same needs to be called in

Line 3812: IF (MSC_CL_COLLECTION.v_coll_prec.supplier_response_flag = MSC_UTIL.SYS_YES and MSC_CL_COLLECTION.v_coll_prec.suprep_sn_flag = MSC_UTIL.SYS_TGT) THEN

3808: IF ( MSC_UTIL.G_MSC_CONFIGURATION = MSC_UTIL.G_CONF_APS_SCE
3809: OR MSC_UTIL.G_MSC_CONFIGURATION = MSC_UTIL.G_CONF_SCE
3810: ) THEN
3811:
3812: IF (MSC_CL_COLLECTION.v_coll_prec.supplier_response_flag = MSC_UTIL.SYS_YES and MSC_CL_COLLECTION.v_coll_prec.suprep_sn_flag = MSC_UTIL.SYS_TGT) THEN
3813:
3814: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Loading Supplier Responses from iSupplier Portal');
3815:
3816: MSC_CL_SUPPLIER_RESP.LOAD_SUPPLIER_RESPONSE

Line 3817: ( MSC_CL_COLLECTION.v_instance_id,

3813:
3814: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Loading Supplier Responses from iSupplier Portal');
3815:
3816: MSC_CL_SUPPLIER_RESP.LOAD_SUPPLIER_RESPONSE
3817: ( MSC_CL_COLLECTION.v_instance_id,
3818: FALSE, --MSC_CL_COLLECTION.v_is_complete_refresh,
3819: TRUE, --MSC_CL_COLLECTION.v_is_partial_refresh,
3820: FALSE, --MSC_CL_COLLECTION.v_is_incremental_refresh,
3821: lv_temp_supply_tbl,

Line 3818: FALSE, --MSC_CL_COLLECTION.v_is_complete_refresh,

3814: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Loading Supplier Responses from iSupplier Portal');
3815:
3816: MSC_CL_SUPPLIER_RESP.LOAD_SUPPLIER_RESPONSE
3817: ( MSC_CL_COLLECTION.v_instance_id,
3818: FALSE, --MSC_CL_COLLECTION.v_is_complete_refresh,
3819: TRUE, --MSC_CL_COLLECTION.v_is_partial_refresh,
3820: FALSE, --MSC_CL_COLLECTION.v_is_incremental_refresh,
3821: lv_temp_supply_tbl,
3822: MSC_CL_COLLECTION.v_current_user,

Line 3819: TRUE, --MSC_CL_COLLECTION.v_is_partial_refresh,

3815:
3816: MSC_CL_SUPPLIER_RESP.LOAD_SUPPLIER_RESPONSE
3817: ( MSC_CL_COLLECTION.v_instance_id,
3818: FALSE, --MSC_CL_COLLECTION.v_is_complete_refresh,
3819: TRUE, --MSC_CL_COLLECTION.v_is_partial_refresh,
3820: FALSE, --MSC_CL_COLLECTION.v_is_incremental_refresh,
3821: lv_temp_supply_tbl,
3822: MSC_CL_COLLECTION.v_current_user,
3823: MSC_CL_COLLECTION.v_last_collection_id);

Line 3820: FALSE, --MSC_CL_COLLECTION.v_is_incremental_refresh,

3816: MSC_CL_SUPPLIER_RESP.LOAD_SUPPLIER_RESPONSE
3817: ( MSC_CL_COLLECTION.v_instance_id,
3818: FALSE, --MSC_CL_COLLECTION.v_is_complete_refresh,
3819: TRUE, --MSC_CL_COLLECTION.v_is_partial_refresh,
3820: FALSE, --MSC_CL_COLLECTION.v_is_incremental_refresh,
3821: lv_temp_supply_tbl,
3822: MSC_CL_COLLECTION.v_current_user,
3823: MSC_CL_COLLECTION.v_last_collection_id);
3824:

Line 3822: MSC_CL_COLLECTION.v_current_user,

3818: FALSE, --MSC_CL_COLLECTION.v_is_complete_refresh,
3819: TRUE, --MSC_CL_COLLECTION.v_is_partial_refresh,
3820: FALSE, --MSC_CL_COLLECTION.v_is_incremental_refresh,
3821: lv_temp_supply_tbl,
3822: MSC_CL_COLLECTION.v_current_user,
3823: MSC_CL_COLLECTION.v_last_collection_id);
3824:
3825: END IF;
3826:

Line 3823: MSC_CL_COLLECTION.v_last_collection_id);

3819: TRUE, --MSC_CL_COLLECTION.v_is_partial_refresh,
3820: FALSE, --MSC_CL_COLLECTION.v_is_incremental_refresh,
3821: lv_temp_supply_tbl,
3822: MSC_CL_COLLECTION.v_current_user,
3823: MSC_CL_COLLECTION.v_last_collection_id);
3824:
3825: END IF;
3826:
3827: END IF;

Line 3843: lv_temp_supply_tbl := 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;

3839: lv_where_clause VARCHAR2(2000);
3840:
3841: BEGIN
3842:
3843: lv_temp_supply_tbl := 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
3844: lv_sql_stmt:=
3845: 'INSERT INTO '||lv_temp_supply_tbl
3846: ||' SELECT * from MSC_SUPPLIES '
3847: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id

Line 3847: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id

3843: lv_temp_supply_tbl := 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
3844: lv_sql_stmt:=
3845: 'INSERT INTO '||lv_temp_supply_tbl
3846: ||' SELECT * from MSC_SUPPLIES '
3847: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
3848: ||' AND plan_id = -1 '
3849: ||' AND order_type NOT IN (';
3850:
3851: -- agmcont:

Line 3853: IF MSC_CL_COLLECTION.v_coll_prec.mps_flag = MSC_UTIL.SYS_YES THEN

3849: ||' AND order_type NOT IN (';
3850:
3851: -- agmcont:
3852:
3853: IF MSC_CL_COLLECTION.v_coll_prec.mps_flag = MSC_UTIL.SYS_YES THEN
3854: if (MSC_CL_COLLECTION.v_is_cont_refresh) then
3855: if (MSC_CL_COLLECTION.v_coll_prec.mps_sn_flag = MSC_UTIL.SYS_TGT) then
3856: lv_where_clause := '5';
3857: end if;

Line 3854: if (MSC_CL_COLLECTION.v_is_cont_refresh) then

3850:
3851: -- agmcont:
3852:
3853: IF MSC_CL_COLLECTION.v_coll_prec.mps_flag = MSC_UTIL.SYS_YES THEN
3854: if (MSC_CL_COLLECTION.v_is_cont_refresh) then
3855: if (MSC_CL_COLLECTION.v_coll_prec.mps_sn_flag = MSC_UTIL.SYS_TGT) then
3856: lv_where_clause := '5';
3857: end if;
3858: else

Line 3855: if (MSC_CL_COLLECTION.v_coll_prec.mps_sn_flag = MSC_UTIL.SYS_TGT) then

3851: -- agmcont:
3852:
3853: IF MSC_CL_COLLECTION.v_coll_prec.mps_flag = MSC_UTIL.SYS_YES THEN
3854: if (MSC_CL_COLLECTION.v_is_cont_refresh) then
3855: if (MSC_CL_COLLECTION.v_coll_prec.mps_sn_flag = MSC_UTIL.SYS_TGT) then
3856: lv_where_clause := '5';
3857: end if;
3858: else
3859: lv_where_clause := '5';

Line 3862: IF (MSC_CL_COLLECTION.v_coll_prec.payback_demand_supply_flag = MSC_UTIL.SYS_YES) THEN

3858: else
3859: lv_where_clause := '5';
3860: end if;
3861: END IF;
3862: IF (MSC_CL_COLLECTION.v_coll_prec.payback_demand_supply_flag = MSC_UTIL.SYS_YES) THEN
3863: IF (lv_where_clause IS NULL) THEN
3864: lv_where_clause := '29';
3865: ELSE
3866: lv_where_clause := lv_where_clause||', 29';

Line 3869: IF (MSC_CL_COLLECTION.v_coll_prec.wip_flag = MSC_UTIL.SYS_YES) THEN

3865: ELSE
3866: lv_where_clause := lv_where_clause||', 29';
3867: END IF;
3868: END IF;
3869: IF (MSC_CL_COLLECTION.v_coll_prec.wip_flag = MSC_UTIL.SYS_YES) THEN
3870:
3871: if (MSC_CL_COLLECTION.v_is_cont_refresh) then
3872: if (MSC_CL_COLLECTION.v_coll_prec.wip_sn_flag = MSC_UTIL.SYS_TGT) then
3873: IF (lv_where_clause IS NULL) THEN

Line 3871: if (MSC_CL_COLLECTION.v_is_cont_refresh) then

3867: END IF;
3868: END IF;
3869: IF (MSC_CL_COLLECTION.v_coll_prec.wip_flag = MSC_UTIL.SYS_YES) THEN
3870:
3871: if (MSC_CL_COLLECTION.v_is_cont_refresh) then
3872: if (MSC_CL_COLLECTION.v_coll_prec.wip_sn_flag = MSC_UTIL.SYS_TGT) then
3873: IF (lv_where_clause IS NULL) THEN
3874: lv_where_clause := '3,7,14,15,16,27,30,70';
3875: ELSE

Line 3872: if (MSC_CL_COLLECTION.v_coll_prec.wip_sn_flag = MSC_UTIL.SYS_TGT) then

3868: END IF;
3869: IF (MSC_CL_COLLECTION.v_coll_prec.wip_flag = MSC_UTIL.SYS_YES) THEN
3870:
3871: if (MSC_CL_COLLECTION.v_is_cont_refresh) then
3872: if (MSC_CL_COLLECTION.v_coll_prec.wip_sn_flag = MSC_UTIL.SYS_TGT) then
3873: IF (lv_where_clause IS NULL) THEN
3874: lv_where_clause := '3,7,14,15,16,27,30,70';
3875: ELSE
3876: lv_where_clause := lv_where_clause||', 3,7,14,15,16,27,30,70';

Line 3891: IF (MSC_CL_COLLECTION.v_coll_prec.po_flag = MSC_UTIL.SYS_YES) THEN

3887:
3888: -- Question what does REPT item - 16 represent?
3889: -- It is assumed that it should be grouped with WIP flag.
3890:
3891: IF (MSC_CL_COLLECTION.v_coll_prec.po_flag = MSC_UTIL.SYS_YES) THEN
3892: if (MSC_CL_COLLECTION.v_is_cont_refresh) then
3893: if (MSC_CL_COLLECTION.v_coll_prec.po_sn_flag = MSC_UTIL.SYS_TGT) then
3894: IF (lv_where_clause IS NULL) THEN
3895: lv_where_clause := '1,2,8,11,12,73,74,87';

Line 3892: if (MSC_CL_COLLECTION.v_is_cont_refresh) then

3888: -- Question what does REPT item - 16 represent?
3889: -- It is assumed that it should be grouped with WIP flag.
3890:
3891: IF (MSC_CL_COLLECTION.v_coll_prec.po_flag = MSC_UTIL.SYS_YES) THEN
3892: if (MSC_CL_COLLECTION.v_is_cont_refresh) then
3893: if (MSC_CL_COLLECTION.v_coll_prec.po_sn_flag = MSC_UTIL.SYS_TGT) then
3894: IF (lv_where_clause IS NULL) THEN
3895: lv_where_clause := '1,2,8,11,12,73,74,87';
3896: ELSE

Line 3893: if (MSC_CL_COLLECTION.v_coll_prec.po_sn_flag = MSC_UTIL.SYS_TGT) then

3889: -- It is assumed that it should be grouped with WIP flag.
3890:
3891: IF (MSC_CL_COLLECTION.v_coll_prec.po_flag = MSC_UTIL.SYS_YES) THEN
3892: if (MSC_CL_COLLECTION.v_is_cont_refresh) then
3893: if (MSC_CL_COLLECTION.v_coll_prec.po_sn_flag = MSC_UTIL.SYS_TGT) then
3894: IF (lv_where_clause IS NULL) THEN
3895: lv_where_clause := '1,2,8,11,12,73,74,87';
3896: ELSE
3897: lv_where_clause := lv_where_clause||', 1,2,8,11,12,73,74,87';

Line 3909: IF (MSC_CL_COLLECTION.v_coll_prec.oh_flag = MSC_UTIL.SYS_YES) THEN

3905: END IF;
3906: end if;
3907: END IF;
3908:
3909: IF (MSC_CL_COLLECTION.v_coll_prec.oh_flag = MSC_UTIL.SYS_YES) THEN
3910: if (MSC_CL_COLLECTION.v_is_cont_refresh) then
3911: if (MSC_CL_COLLECTION.v_coll_prec.oh_sn_flag = MSC_UTIL.SYS_TGT) then
3912: IF (lv_where_clause IS NULL) THEN
3913: lv_where_clause := '18';

Line 3910: if (MSC_CL_COLLECTION.v_is_cont_refresh) then

3906: end if;
3907: END IF;
3908:
3909: IF (MSC_CL_COLLECTION.v_coll_prec.oh_flag = MSC_UTIL.SYS_YES) THEN
3910: if (MSC_CL_COLLECTION.v_is_cont_refresh) then
3911: if (MSC_CL_COLLECTION.v_coll_prec.oh_sn_flag = MSC_UTIL.SYS_TGT) then
3912: IF (lv_where_clause IS NULL) THEN
3913: lv_where_clause := '18';
3914: ELSE

Line 3911: if (MSC_CL_COLLECTION.v_coll_prec.oh_sn_flag = MSC_UTIL.SYS_TGT) then

3907: END IF;
3908:
3909: IF (MSC_CL_COLLECTION.v_coll_prec.oh_flag = MSC_UTIL.SYS_YES) THEN
3910: if (MSC_CL_COLLECTION.v_is_cont_refresh) then
3911: if (MSC_CL_COLLECTION.v_coll_prec.oh_sn_flag = MSC_UTIL.SYS_TGT) then
3912: IF (lv_where_clause IS NULL) THEN
3913: lv_where_clause := '18';
3914: ELSE
3915: lv_where_clause := lv_where_clause||', 18';

Line 3927: IF (MSC_CL_COLLECTION.v_coll_prec.internal_repair_flag = MSC_UTIL.SYS_YES) THEN

3923: END IF;
3924: end if;
3925: END IF;
3926:
3927: IF (MSC_CL_COLLECTION.v_coll_prec.internal_repair_flag = MSC_UTIL.SYS_YES) THEN
3928: if (MSC_CL_COLLECTION.v_is_cont_refresh) then
3929: NULL;
3930: Else
3931:

Line 3928: if (MSC_CL_COLLECTION.v_is_cont_refresh) then

3924: end if;
3925: END IF;
3926:
3927: IF (MSC_CL_COLLECTION.v_coll_prec.internal_repair_flag = MSC_UTIL.SYS_YES) THEN
3928: if (MSC_CL_COLLECTION.v_is_cont_refresh) then
3929: NULL;
3930: Else
3931:
3932: IF (lv_where_clause IS NULL) THEN

Line 3941: IF (MSC_CL_COLLECTION.v_coll_prec.external_repair_flag = MSC_UTIL.SYS_YES) THEN

3937: end if;
3938:
3939: END IF; -- Added for 5909379 SRP Additions
3940:
3941: IF (MSC_CL_COLLECTION.v_coll_prec.external_repair_flag = MSC_UTIL.SYS_YES) THEN
3942: if (MSC_CL_COLLECTION.v_is_cont_refresh) then
3943: NULL;
3944: Else
3945:

Line 3942: if (MSC_CL_COLLECTION.v_is_cont_refresh) then

3938:
3939: END IF; -- Added for 5909379 SRP Additions
3940:
3941: IF (MSC_CL_COLLECTION.v_coll_prec.external_repair_flag = MSC_UTIL.SYS_YES) THEN
3942: if (MSC_CL_COLLECTION.v_is_cont_refresh) then
3943: NULL;
3944: Else
3945:
3946: IF (lv_where_clause IS NULL) THEN

Line 3956: IF (MSC_CL_COLLECTION.v_coll_prec.user_supply_demand_flag = MSC_UTIL.SYS_YES) THEN

3952:
3953: END IF; -- Added for 5935273 SRP Additions
3954:
3955:
3956: IF (MSC_CL_COLLECTION.v_coll_prec.user_supply_demand_flag = MSC_UTIL.SYS_YES) THEN
3957: if (MSC_CL_COLLECTION.v_is_cont_refresh) then
3958: if (MSC_CL_COLLECTION.v_coll_prec.usup_sn_flag = MSC_UTIL.SYS_TGT) then
3959: IF (lv_where_clause IS NULL) THEN
3960: lv_where_clause := '41';

Line 3957: if (MSC_CL_COLLECTION.v_is_cont_refresh) then

3953: END IF; -- Added for 5935273 SRP Additions
3954:
3955:
3956: IF (MSC_CL_COLLECTION.v_coll_prec.user_supply_demand_flag = MSC_UTIL.SYS_YES) THEN
3957: if (MSC_CL_COLLECTION.v_is_cont_refresh) then
3958: if (MSC_CL_COLLECTION.v_coll_prec.usup_sn_flag = MSC_UTIL.SYS_TGT) then
3959: IF (lv_where_clause IS NULL) THEN
3960: lv_where_clause := '41';
3961: ELSE

Line 3958: if (MSC_CL_COLLECTION.v_coll_prec.usup_sn_flag = MSC_UTIL.SYS_TGT) then

3954:
3955:
3956: IF (MSC_CL_COLLECTION.v_coll_prec.user_supply_demand_flag = MSC_UTIL.SYS_YES) THEN
3957: if (MSC_CL_COLLECTION.v_is_cont_refresh) then
3958: if (MSC_CL_COLLECTION.v_coll_prec.usup_sn_flag = MSC_UTIL.SYS_TGT) then
3959: IF (lv_where_clause IS NULL) THEN
3960: lv_where_clause := '41';
3961: ELSE
3962: lv_where_clause := lv_where_clause||', 41';

Line 3976: IF (MSC_CL_COLLECTION.v_coll_prec.supplier_response_flag = MSC_UTIL.SYS_YES) THEN

3972: END IF;
3973:
3974: /* CP-ACK starts */
3975:
3976: IF (MSC_CL_COLLECTION.v_coll_prec.supplier_response_flag = MSC_UTIL.SYS_YES) THEN
3977:
3978: /* CP-AUTO */
3979: IF (MSC_CL_COLLECTION.v_is_cont_refresh) then
3980:

Line 3979: IF (MSC_CL_COLLECTION.v_is_cont_refresh) then

3975:
3976: IF (MSC_CL_COLLECTION.v_coll_prec.supplier_response_flag = MSC_UTIL.SYS_YES) THEN
3977:
3978: /* CP-AUTO */
3979: IF (MSC_CL_COLLECTION.v_is_cont_refresh) then
3980:
3981: IF (MSC_CL_COLLECTION.v_coll_prec.suprep_sn_flag = MSC_UTIL.SYS_TGT) THEN
3982:
3983: IF (lv_where_clause IS NULL) THEN

Line 3981: IF (MSC_CL_COLLECTION.v_coll_prec.suprep_sn_flag = MSC_UTIL.SYS_TGT) THEN

3977:
3978: /* CP-AUTO */
3979: IF (MSC_CL_COLLECTION.v_is_cont_refresh) then
3980:
3981: IF (MSC_CL_COLLECTION.v_coll_prec.suprep_sn_flag = MSC_UTIL.SYS_TGT) THEN
3982:
3983: IF (lv_where_clause IS NULL) THEN
3984: lv_where_clause := MSC_CL_COLLECTION.G_MRP_PO_ACK;
3985: ELSE

Line 3984: lv_where_clause := MSC_CL_COLLECTION.G_MRP_PO_ACK;

3980:
3981: IF (MSC_CL_COLLECTION.v_coll_prec.suprep_sn_flag = MSC_UTIL.SYS_TGT) THEN
3982:
3983: IF (lv_where_clause IS NULL) THEN
3984: lv_where_clause := MSC_CL_COLLECTION.G_MRP_PO_ACK;
3985: ELSE
3986: lv_where_clause := lv_where_clause||', '||MSC_CL_COLLECTION.G_MRP_PO_ACK;
3987: END IF;
3988:

Line 3986: lv_where_clause := lv_where_clause||', '||MSC_CL_COLLECTION.G_MRP_PO_ACK;

3982:
3983: IF (lv_where_clause IS NULL) THEN
3984: lv_where_clause := MSC_CL_COLLECTION.G_MRP_PO_ACK;
3985: ELSE
3986: lv_where_clause := lv_where_clause||', '||MSC_CL_COLLECTION.G_MRP_PO_ACK;
3987: END IF;
3988:
3989: END IF;
3990:

Line 3994: lv_where_clause := MSC_CL_COLLECTION.G_MRP_PO_ACK;

3990:
3991: ELSE
3992:
3993: IF (lv_where_clause IS NULL) THEN
3994: lv_where_clause := MSC_CL_COLLECTION.G_MRP_PO_ACK;
3995: ELSE
3996: lv_where_clause := lv_where_clause||', '||MSC_CL_COLLECTION.G_MRP_PO_ACK;
3997: END IF;
3998:

Line 3996: lv_where_clause := lv_where_clause||', '||MSC_CL_COLLECTION.G_MRP_PO_ACK;

3992:
3993: IF (lv_where_clause IS NULL) THEN
3994: lv_where_clause := MSC_CL_COLLECTION.G_MRP_PO_ACK;
3995: ELSE
3996: lv_where_clause := lv_where_clause||', '||MSC_CL_COLLECTION.G_MRP_PO_ACK;
3997: END IF;
3998:
3999: END IF;
4000:

Line 4012: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN

4008: -- For that purpose complete refresh needs to be run.
4009:
4010: lv_sql_stmt := lv_sql_stmt||lv_where_clause ||' )';
4011:
4012: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
4013: null;
4014: ELSE
4015: lv_sql_stmt1:= ' UNION ALL '
4016: ||' SELECT * from MSC_SUPPLIES '

Line 4017: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id

4013: null;
4014: ELSE
4015: lv_sql_stmt1:= ' UNION ALL '
4016: ||' SELECT * from MSC_SUPPLIES '
4017: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
4018: ||' AND plan_id = -1 '
4019: ||' AND organization_id not '||MSC_UTIL.v_in_org_str
4020: ||' AND order_type IN (';
4021:

Line 4025: if NOT (MSC_CL_COLLECTION.v_is_complete_refresh) then

4021:
4022: lv_sql_stmt1 := lv_sql_stmt1||lv_where_clause ||' )';
4023:
4024:
4025: if NOT (MSC_CL_COLLECTION.v_is_complete_refresh) then
4026: lv_sql_stmt :=lv_sql_stmt||lv_sql_stmt1;
4027: else
4028: lv_sql_stmt := lv_sql_stmt||' AND organization_id NOT '||MSC_UTIL.v_in_org_str;
4029:

Line 4043: set SUPPLIES_LOAD_FLAG = MSC_CL_COLLECTION.G_JOB_ERROR

4039:
4040: EXCEPTION
4041: WHEN OTHERS THEN
4042: update msc_apps_instances
4043: set SUPPLIES_LOAD_FLAG = MSC_CL_COLLECTION.G_JOB_ERROR
4044: where instance_id = MSC_CL_COLLECTION.v_instance_id;
4045: commit;
4046:
4047: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 4044: where instance_id = MSC_CL_COLLECTION.v_instance_id;

4040: EXCEPTION
4041: WHEN OTHERS THEN
4042: update msc_apps_instances
4043: set SUPPLIES_LOAD_FLAG = MSC_CL_COLLECTION.G_JOB_ERROR
4044: where instance_id = MSC_CL_COLLECTION.v_instance_id;
4045: commit;
4046:
4047: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4048: RAISE;

Line 4059: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN

4055: lv_sql_stmt VARCHAR2(32767);
4056:
4057: BEGIN
4058:
4059: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
4060: lv_supply_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
4061: ELSE
4062: lv_supply_tbl:= 'MSC_SUPPLIES';
4063: END IF;

Line 4060: lv_supply_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;

4056:
4057: BEGIN
4058:
4059: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
4060: lv_supply_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
4061: ELSE
4062: lv_supply_tbl:= 'MSC_SUPPLIES';
4063: END IF;
4064:

Line 4108: USING MSC_CL_COLLECTION.v_current_date,

4104: AND MOP.sr_instance_id = :v_instance_id';
4105:
4106:
4107: EXECUTE IMMEDIATE lv_sql_stmt
4108: USING MSC_CL_COLLECTION.v_current_date,
4109: MSC_CL_COLLECTION.v_current_user,
4110: MSC_CL_COLLECTION.v_current_date,
4111: MSC_CL_COLLECTION.v_current_user,
4112: MSC_CL_COLLECTION.v_instance_id;

Line 4109: MSC_CL_COLLECTION.v_current_user,

4105:
4106:
4107: EXECUTE IMMEDIATE lv_sql_stmt
4108: USING MSC_CL_COLLECTION.v_current_date,
4109: MSC_CL_COLLECTION.v_current_user,
4110: MSC_CL_COLLECTION.v_current_date,
4111: MSC_CL_COLLECTION.v_current_user,
4112: MSC_CL_COLLECTION.v_instance_id;
4113:

Line 4110: MSC_CL_COLLECTION.v_current_date,

4106:
4107: EXECUTE IMMEDIATE lv_sql_stmt
4108: USING MSC_CL_COLLECTION.v_current_date,
4109: MSC_CL_COLLECTION.v_current_user,
4110: MSC_CL_COLLECTION.v_current_date,
4111: MSC_CL_COLLECTION.v_current_user,
4112: MSC_CL_COLLECTION.v_instance_id;
4113:
4114: COMMIT;

Line 4111: MSC_CL_COLLECTION.v_current_user,

4107: EXECUTE IMMEDIATE lv_sql_stmt
4108: USING MSC_CL_COLLECTION.v_current_date,
4109: MSC_CL_COLLECTION.v_current_user,
4110: MSC_CL_COLLECTION.v_current_date,
4111: MSC_CL_COLLECTION.v_current_user,
4112: MSC_CL_COLLECTION.v_instance_id;
4113:
4114: COMMIT;
4115: END LOAD_PAYBACK_SUPPLIES;

Line 4112: MSC_CL_COLLECTION.v_instance_id;

4108: USING MSC_CL_COLLECTION.v_current_date,
4109: MSC_CL_COLLECTION.v_current_user,
4110: MSC_CL_COLLECTION.v_current_date,
4111: MSC_CL_COLLECTION.v_current_user,
4112: MSC_CL_COLLECTION.v_instance_id;
4113:
4114: COMMIT;
4115: END LOAD_PAYBACK_SUPPLIES;
4116: