APPS.MSC_X_HZ_PLAN dependencies on DUAL

Line 1757: * into individual variables.

1753:
1754:
1755: /**
1756: * The following procedure sets the date buckets
1757: * into individual variables.
1758: * This is required to insert into the headers table.
1759: */
1760: PROCEDURE set_date_variables IS
1761:

Line 2173: select sys_context('MSC','COMPANY_ID') into v_viewer_id from dual;

2169: l_base_qty number := 0;
2170: l_config_qty number := 0;
2171: BEGIN
2172:
2173: select sys_context('MSC','COMPANY_ID') into v_viewer_id from dual;
2174:
2175: if tpco_agg = ORG_AGG THEN
2176:
2177: if myco_agg = ORG_AGG THEN

Line 2730: select msc_form_query_s.nextval into l_query_id from dual;

2726:
2727: -- insert all the items of the category into temp table msc_form_query.
2728: -- store all the item ids in number1 column of msc_form_query temp table.
2729: if (v_category is not null) then
2730: select msc_form_query_s.nextval into l_query_id from dual;
2731: OPEN category_items(v_category);
2732: LOOP
2733: FETCH category_items into l_item_id;
2734: EXIT WHEN category_items%NOTFOUND;

Line 4039: SELECT msc_x_hz_ui_query_id_s.nextval INTO arg_query_id FROM Dual;

4035:
4036: --massage ss and pab data
4037: --fill_ss_pab_empty_buckets;
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,