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.GHG_ORG_ACCOUNT_MAPPINGS_PKG dependencies on GHG_ORG_ACCOUNT_MAPPINGS_ALL

Line 82: FROM GHG_org_account_mappings_all

78: v_debug_info VARCHAR2(100);
79:
80: CURSOR c IS
81: SELECT ROWID
82: FROM GHG_org_account_mappings_all
83: WHERE account_mapping_id = x_facility_mapping_id;
84:
85: BEGIN
86:

Line 87: v_debug_info := 'Inserting into GHG_org_account_mappings_all';

83: WHERE account_mapping_id = x_facility_mapping_id;
84:
85: BEGIN
86:
87: v_debug_info := 'Inserting into GHG_org_account_mappings_all';
88:
89: INSERT INTO GHG_ORG_ACCOUNT_MAPPINGS_all (account_mapping_id,
90: ghg_organization_id,
91: segment1_low,

Line 89: INSERT INTO GHG_ORG_ACCOUNT_MAPPINGS_all (account_mapping_id,

85: BEGIN
86:
87: v_debug_info := 'Inserting into GHG_org_account_mappings_all';
88:
89: INSERT INTO GHG_ORG_ACCOUNT_MAPPINGS_all (account_mapping_id,
90: ghg_organization_id,
91: segment1_low,
92: segment1_high,
93: segment2_low,

Line 338: v_debug_info := 'Updating GHG_ORG_ACCOUNT_MAPPINGS_all';

334: v_debug_info VARCHAR2(100);
335:
336: BEGIN
337:
338: v_debug_info := 'Updating GHG_ORG_ACCOUNT_MAPPINGS_all';
339:
340: UPDATE GHG_org_account_mappings_all
341: SET account_mapping_id = x_facility_mapping_id,
342: ghg_organization_id = x_facility_id,

Line 340: UPDATE GHG_org_account_mappings_all

336: BEGIN
337:
338: v_debug_info := 'Updating GHG_ORG_ACCOUNT_MAPPINGS_all';
339:
340: UPDATE GHG_org_account_mappings_all
341: SET account_mapping_id = x_facility_mapping_id,
342: ghg_organization_id = x_facility_id,
343: segment1_low = x_segment1_low,
344: segment1_high = x_segment1_low,

Line 436: DELETE FROM GHG_org_account_mappings_all

432: v_row_count NUMBER(15);
433:
434: BEGIN
435:
436: DELETE FROM GHG_org_account_mappings_all
437: WHERE account_mapping_id = x_facility_mapping_id;
438:
439: IF (sql%notfound) THEN
440: RAISE no_data_found;

Line 594: FROM GHG_org_account_mappings_all

590: creation_date,
591: last_updated_by,
592: last_update_date,
593: last_update_login
594: FROM GHG_org_account_mappings_all
595: WHERE rowid = x_rowid
596: FOR UPDATE of account_mapping_id NOWAIT;
597: recinfo C%ROWTYPE;
598:

Line 730: FROM ghg_org_account_mappings_all

726: BEGIN
727:
728: SELECT chart_of_accounts_id
729: INTO v_chart_of_acc_id
730: FROM ghg_org_account_mappings_all
731: WHERE account_mapping_id = v_facility_mapping_id;
732:
733: v_sqltext := 'SELECT count(*) FROM gl_code_combinations gc, ap_invoice_distributions_all ai, ghg_transactions_all gt, ghg_org_account_mappings_all ga ';
734: v_sqltext := v_sqltext || 'WHERE gc.code_combination_id = ai.dist_code_combination_id AND ai.invoice_id = gt.invoice_id ';

Line 733: v_sqltext := 'SELECT count(*) FROM gl_code_combinations gc, ap_invoice_distributions_all ai, ghg_transactions_all gt, ghg_org_account_mappings_all ga ';

729: INTO v_chart_of_acc_id
730: FROM ghg_org_account_mappings_all
731: WHERE account_mapping_id = v_facility_mapping_id;
732:
733: v_sqltext := 'SELECT count(*) FROM gl_code_combinations gc, ap_invoice_distributions_all ai, ghg_transactions_all gt, ghg_org_account_mappings_all ga ';
734: v_sqltext := v_sqltext || 'WHERE gc.code_combination_id = ai.dist_code_combination_id AND ai.invoice_id = gt.invoice_id ';
735: v_sqltext := v_sqltext || 'AND gt.ghg_organization_id = ga.ghg_organization_id AND gt.invoice_id IS NOT NULL AND gc.chart_of_accounts_id = ga.chart_of_accounts_id ';
736: v_sqltext := v_sqltext || 'AND ga.account_mapping_id = '||v_facility_mapping_id;
737: