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.PN_VAR_DEFAULTS_PKG dependencies on PN_VAR_LINES_ALL

Line 453: | Create records in the PN_VAR_LINES_ALL table from date range lines.

449: | PROCEDURE CREATE_DEFAULT_LINES
450: |
451: |
452: | DESCRIPTION
453: | Create records in the PN_VAR_LINES_ALL table from date range lines.
454: |
455: | SCOPE - PUBLIC
456: |
457: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED

Line 584: from pn_var_lines_all

580: IS
581: SELECT 'x' line_exists
582: FROM dual
583: WHERE exists ( select line_item_id
584: from pn_var_lines_all
585: where period_id = ip_period_id
586: and item_category_code = ip_item_category_code
587: and sales_type_code = ip_sales_type_code);
588:

Line 596: from pn_var_lines_all

592: IS
593: SELECT 'x' line_exists
594: FROM dual
595: WHERE exists ( select line_item_id
596: from pn_var_lines_all
597: where period_id = ip_period_id
598: and sales_type_code = ip_sales_type_code
599: and rownum <2);
600:

Line 606: from pn_var_lines_all

602: IS
603: SELECT 'x' line_exists
604: FROM dual
605: WHERE exists ( select line_item_id
606: from pn_var_lines_all
607: where period_id = ip_period_id
608: and item_category_code = ip_item_category_code
609: and rownum <2);
610: /* codev changes ends */

Line 749: FROM pn_var_lines_all

745: */
746: ELSE
747: SELECT line_item_id
748: INTO l_line_item_id
749: FROM pn_var_lines_all
750: WHERE line_default_id = c_line_rec.line_default_id
751: AND period_id = c_period_rec.period_id
752: AND var_rent_id = l_var_rent_id
753: AND ROWNUM = 1;

Line 1182: FROM pn_var_lines_all

1178: WHERE var_rent_id = X_VAR_RENT_ID;
1179:
1180: /*DELETE FROM pn_var_vol_hist_all
1181: WHERE line_item_id IN (SELECT line_item_id
1182: FROM pn_var_lines_all
1183: WHERE var_rent_id = X_VAR_RENT_ID);
1184:
1185: DELETE FROM pn_var_lines_all
1186: WHERE var_rent_id = X_VAR_RENT_ID;

Line 1185: DELETE FROM pn_var_lines_all

1181: WHERE line_item_id IN (SELECT line_item_id
1182: FROM pn_var_lines_all
1183: WHERE var_rent_id = X_VAR_RENT_ID);
1184:
1185: DELETE FROM pn_var_lines_all
1186: WHERE var_rent_id = X_VAR_RENT_ID;
1187:
1188: DELETE FROM pn_var_transactions_all
1189: WHERE var_rent_id = X_VAR_RENT_ID;*/

Line 1232: DELETE FROM pn_var_lines_all

1228: WHERE var_rent_id = X_VAR_RENT_ID
1229: AND bkhd_default_id <> x_bkhd_default_id); */
1230:
1231: /* commented by parag
1232: DELETE FROM pn_var_lines_all
1233: WHERE var_rent_id = X_VAR_RENT_ID
1234: AND line_item_id IN (SELECT line_item_id
1235: FROM pn_var_bkpts_head_all
1236: WHERE bkhd_default_id = x_bkhd_default_id)

Line 1287: DELETE FROM pn_var_lines_all

1283: FROM pn_var_bkpts_head_all
1284: WHERE var_rent_id = X_VAR_RENT_ID
1285: AND bkpt_header_id <> x_bkpt_header_id);
1286:
1287: DELETE FROM pn_var_lines_all
1288: WHERE var_rent_id = X_VAR_RENT_ID
1289: AND line_item_id IN (SELECT line_item_id
1290: FROM pn_var_bkpts_head_all
1291: WHERE bkpt_header_id = x_bkpt_header_id)

Line 2009: | Creates records in the PN_VAR_LINES_ALL, PN_VAR_BPKT_HEAD_ALL and

2005: | PROCEDURE CREATE_SETUP_DATA
2006: |
2007: |
2008: | DESCRIPTION
2009: | Creates records in the PN_VAR_LINES_ALL, PN_VAR_BPKT_HEAD_ALL and
2010: | PN_VAR_BKPT_DET_ALL tables from DEFAULTS tables
2011: |
2012: | SCOPE - PUBLIC
2013: |

Line 2103: FROM pn_var_lines_all

2099: CURSOR line_exists_cur (p_line_def_id NUMBER
2100: ,p_period_id NUMBER)
2101: IS
2102: SELECT line_item_id
2103: FROM pn_var_lines_all
2104: WHERE line_default_id = p_line_def_id
2105: AND period_id = p_period_id;
2106:
2107:

Line 2166: /* Inserting line defaults data into PN_VAR_LINES_ALL */

2162: dbms_output.put_line('l_line_item_id '||l_line_item_id);*/
2163:
2164: IF l_line_item_id IS NULL THEN
2165:
2166: /* Inserting line defaults data into PN_VAR_LINES_ALL */
2167:
2168: l_rowid := NULL;
2169: l_line_item_num := NULL;
2170:

Line 2209: /* UPDATE PN_VAR_LINES_ALL, using data from PN_VAR_LINE_DEFAULTS_ALL */

2205:
2206:
2207: ELSE
2208:
2209: /* UPDATE PN_VAR_LINES_ALL, using data from PN_VAR_LINE_DEFAULTS_ALL */
2210:
2211: /*dbms_output.put_line('at update');
2212: dbms_output.put_line('l_line_item_id '||l_line_item_id);*/
2213:

Line 2214: UPDATE PN_VAR_LINES_ALL SET

2210:
2211: /*dbms_output.put_line('at update');
2212: dbms_output.put_line('l_line_item_id '||l_line_item_id);*/
2213:
2214: UPDATE PN_VAR_LINES_ALL SET
2215: PERIOD_ID = per_rec.period_id,
2216: SALES_TYPE_CODE = line_def_rec.sales_type_code,
2217: ITEM_CATEGORY_CODE = line_def_rec.item_category_code,
2218: ATTRIBUTE_CATEGORY = line_def_rec.attribute_category,

Line 2363: UPDATE pn_var_lines_all

2359: UPDATE pn_var_bkhd_defaults_all
2360: SET bkpt_update_flag = 'N'
2361: WHERE var_rent_id = l_var_rent_id;
2362:
2363: UPDATE pn_var_lines_all
2364: SET bkpt_update_flag = 'Y'
2365: WHERE var_rent_id = l_var_rent_id;
2366:
2367: PNP_DEBUG_PKG.log('PN_VAR_DEFAULTS_PKG.CREATE_SETUP_DATA (-)');