APPS.MSC_X_HZ_PLAN dependencies on MSC_HZ_UI_HEADERS

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

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

Line 4043: INSERT INTO msc_hz_ui_headers

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

Line 4275: FROM msc_hz_ui_headers

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

Line 4765: UPDATE msc_hz_ui_headers

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

Line 4769: UPDATE msc_hz_ui_headers

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