APPS.MSC_X_HZ_PLAN dependencies on MSC_HZ_UI_HEADERS

Line 3957: * insert the buckets into the msc_hz_ui_headers table.

3953: *
3954: * loop though the plans.
3955: * get dates.
3956: * get the number of buckets to be displayed.
3957: * insert the buckets into the msc_hz_ui_headers table.
3958: */
3959:
3960:
3961: BEGIN

Line 4042: INSERT INTO msc_hz_ui_headers

4038: -- get the query id first
4039: SELECT msc_x_hz_ui_query_id_s.nextval INTO arg_query_id FROM Dual;
4040:
4041: -- insert the header
4042: INSERT INTO msc_hz_ui_headers
4043: (QUERY_ID,NO_OF_BUCKETS,PROD_SUM_LEVEL, ORG_SUM_LEVEL, ORG_SUM_LEVEL_TP,
4044: BUCKET1,BUCKET2,BUCKET3,BUCKET4,BUCKET5,BUCKET6,BUCKET7,BUCKET8,BUCKET9,
4045: BUCKET10,BUCKET11,BUCKET12,BUCKET13,BUCKET14,BUCKET15,BUCKET16,BUCKET17,
4046: BUCKET18,BUCKET19,BUCKET20,BUCKET21,BUCKET22,BUCKET23,BUCKET24,BUCKET25,

Line 4274: FROM msc_hz_ui_headers

4270: -- records from the relation array
4271: BEGIN
4272: SELECT nvl(no_of_buckets,NOT_SELECTED)
4273: INTO record_cnt
4274: FROM msc_hz_ui_headers
4275: WHERE query_id = arg_query_id ;
4276:
4277: EXCEPTION
4278: when no_data_found then

Line 4764: UPDATE msc_hz_ui_headers

4760:
4761: BEGIN
4762: -- now update the undated_buckets value int the header
4763: if unbucketed_flag > 0 then
4764: UPDATE msc_hz_ui_headers
4765: SET undated_bucket_flag = 'Y'
4766: WHERE query_id = arg_query_id;
4767: else
4768: UPDATE msc_hz_ui_headers

Line 4768: UPDATE msc_hz_ui_headers

4764: UPDATE msc_hz_ui_headers
4765: SET undated_bucket_flag = 'Y'
4766: WHERE query_id = arg_query_id;
4767: else
4768: UPDATE msc_hz_ui_headers
4769: SET undated_bucket_flag = 'N'
4770: WHERE query_id = arg_query_id;
4771:
4772: end if;