DBA Data[Home] [Help]

APPS.CHV_BUILD_SCHEDULES dependencies on CHV_CREATE_BUCKETS

Line 102: x_bucket_descriptor_table chv_create_buckets.bkttable;

98: x_str VARCHAR2(480);
99: x_org_id NUMBER; /* Bug 2616988 fixed. added x_org_id */
100:
101: -- 3 PL/SQL tables used for calculating bucket quantities.
102: x_bucket_descriptor_table chv_create_buckets.bkttable;
103: x_bucket_start_date_table chv_create_buckets.bkttable;
104: x_bucket_end_date_table chv_create_buckets.bkttable;
105:
106: -- The MRP, MPS, or DRP Designator will optionally be passed in.

Line 103: x_bucket_start_date_table chv_create_buckets.bkttable;

99: x_org_id NUMBER; /* Bug 2616988 fixed. added x_org_id */
100:
101: -- 3 PL/SQL tables used for calculating bucket quantities.
102: x_bucket_descriptor_table chv_create_buckets.bkttable;
103: x_bucket_start_date_table chv_create_buckets.bkttable;
104: x_bucket_end_date_table chv_create_buckets.bkttable;
105:
106: -- The MRP, MPS, or DRP Designator will optionally be passed in.
107: -- From the WB we will default the designator into the fields

Line 104: x_bucket_end_date_table chv_create_buckets.bkttable;

100:
101: -- 3 PL/SQL tables used for calculating bucket quantities.
102: x_bucket_descriptor_table chv_create_buckets.bkttable;
103: x_bucket_start_date_table chv_create_buckets.bkttable;
104: x_bucket_end_date_table chv_create_buckets.bkttable;
105:
106: -- The MRP, MPS, or DRP Designator will optionally be passed in.
107: -- From the WB we will default the designator into the fields
108: -- from the org options. The user has the option to change

Line 532: chv_create_buckets.create_bucket_template(p_horizon_start_date,

528: ---- dbms_output.put_line('Build_schedule: create_bucket_template');
529:
530: x_progress := '040';
531:
532: chv_create_buckets.create_bucket_template(p_horizon_start_date,
533: p_include_future_releases,
534: x_bucket_pattern_id,
535: x_horizon_end_date,
536: x_bucket_descriptor_table,

Line 1309: x_bucket_descriptor_table in out NOCOPY chv_create_buckets.BKTTABLE,

1305: p_planner_code in VARCHAR2,
1306: x_user_id in NUMBER,
1307: x_login_id in NUMBER,
1308: x_horizon_end_date in DATE,
1309: x_bucket_descriptor_table in out NOCOPY chv_create_buckets.BKTTABLE,
1310: x_bucket_start_date_table in out NOCOPY chv_create_buckets.BKTTABLE,
1311: x_bucket_end_date_table in out NOCOPY chv_create_buckets.BKTTABLE,
1312: x_item_created in out NOCOPY VARCHAR2,
1313: x_old_schedule_id in NUMBER,

Line 1310: x_bucket_start_date_table in out NOCOPY chv_create_buckets.BKTTABLE,

1306: x_user_id in NUMBER,
1307: x_login_id in NUMBER,
1308: x_horizon_end_date in DATE,
1309: x_bucket_descriptor_table in out NOCOPY chv_create_buckets.BKTTABLE,
1310: x_bucket_start_date_table in out NOCOPY chv_create_buckets.BKTTABLE,
1311: x_bucket_end_date_table in out NOCOPY chv_create_buckets.BKTTABLE,
1312: x_item_created in out NOCOPY VARCHAR2,
1313: x_old_schedule_id in NUMBER,
1314: p_bucket_pattern_id in NUMBER,

Line 1311: x_bucket_end_date_table in out NOCOPY chv_create_buckets.BKTTABLE,

1307: x_login_id in NUMBER,
1308: x_horizon_end_date in DATE,
1309: x_bucket_descriptor_table in out NOCOPY chv_create_buckets.BKTTABLE,
1310: x_bucket_start_date_table in out NOCOPY chv_create_buckets.BKTTABLE,
1311: x_bucket_end_date_table in out NOCOPY chv_create_buckets.BKTTABLE,
1312: x_item_created in out NOCOPY VARCHAR2,
1313: x_old_schedule_id in NUMBER,
1314: p_bucket_pattern_id in NUMBER,
1315: p_schedule_subtype in VARCHAR2,

Line 2037: chv_create_buckets.calculate_buckets( x_schedule_id,

2033: ---- dbms_output.put_line('Create_items: cum enabled'||x_enable_cum_flag_l);
2034: ---- dbms_output.put_line('Create_items: cum qty'||x_cum_quantity_received_l);
2035:
2036: x_progress := '150';
2037: chv_create_buckets.calculate_buckets( x_schedule_id,
2038: x_schedule_item_id_l,
2039: p_horizon_start_date,
2040: x_horizon_end_date,
2041: x_schedule_subtype,