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.GMF_SUBLEDGER_PKG dependencies on ORG_ACCT_PERIODS

Line 139: l_inv_fiscal_year org_acct_periods.period_year%TYPE;

135: /* Start INVCONV umoogala
136: l_inv_fiscal_year ic_cldr_dtl.fiscal_year%TYPE;
137: l_inv_period ic_cldr_dtl.period%TYPE;
138: */
139: l_inv_fiscal_year org_acct_periods.period_year%TYPE;
140: l_inv_period org_acct_periods.period_num%TYPE;
141:
142: l_subledger_ref_no NUMBER(15) := NULL;
143:

Line 140: l_inv_period org_acct_periods.period_num%TYPE;

136: l_inv_fiscal_year ic_cldr_dtl.fiscal_year%TYPE;
137: l_inv_period ic_cldr_dtl.period%TYPE;
138: */
139: l_inv_fiscal_year org_acct_periods.period_year%TYPE;
140: l_inv_period org_acct_periods.period_num%TYPE;
141:
142: l_subledger_ref_no NUMBER(15) := NULL;
143:
144: l_conc_id NUMBER(15) := 0;

Line 808: l_inv_fiscal_year org_acct_periods.period_year%TYPE := NULL;

804: l_co_source VARCHAR2(1);
805: l_source_selected BOOLEAN;
806:
807: l_retstatus VARCHAR2(1);
808: l_inv_fiscal_year org_acct_periods.period_year%TYPE := NULL;
809: l_inv_period org_acct_periods.period_num%TYPE := NULL;
810: l_errbuf VARCHAR2(2000);
811: l_lot_actual_cost NUMBER := 0;
812: l_post_cm VARCHAR2(2);

Line 809: l_inv_period org_acct_periods.period_num%TYPE := NULL;

805: l_source_selected BOOLEAN;
806:
807: l_retstatus VARCHAR2(1);
808: l_inv_fiscal_year org_acct_periods.period_year%TYPE := NULL;
809: l_inv_period org_acct_periods.period_num%TYPE := NULL;
810: l_errbuf VARCHAR2(2000);
811: l_lot_actual_cost NUMBER := 0;
812: l_post_cm VARCHAR2(2);
813:

Line 1528: FROM org_acct_periods oap,

1524: p_period_id NUMBER
1525: )
1526: IS
1527: SELECT nvl(SUM(decode(nvl(gpb.period_close_status,'~'),'F',1,'P',1, 0)),0) as close_status
1528: FROM org_acct_periods oap,
1529: hr_organization_information hoi,
1530: mtl_parameters mp,
1531: gmf_period_statuses gps,
1532: gl_ledgers gl,

Line 1688: FROM org_acct_periods oap,

1684: SELECT period_year,
1685: period_num
1686: INTO x_inv_fiscal_year,
1687: x_inv_period
1688: FROM org_acct_periods oap,
1689: hr_organization_information hoi,
1690: gmf_period_statuses gps,
1691: gl_ledgers gl
1692: WHERE gps.period_id = l_prior_period_id

Line 1849: org_acct_periods d1,

1845: d1.period_year fiscal_year, d1.period_num period,
1846: d1.period_start_date begin_date, d2.schedule_close_date period_end_date
1847: FROM
1848: org_organization_definitions org,
1849: org_acct_periods d1,
1850: org_acct_periods d2
1851: WHERE
1852: org.legal_entity = cp_le_id
1853: AND d2.period_year = d1.period_year

Line 1850: org_acct_periods d2

1846: d1.period_start_date begin_date, d2.schedule_close_date period_end_date
1847: FROM
1848: org_organization_definitions org,
1849: org_acct_periods d1,
1850: org_acct_periods d2
1851: WHERE
1852: org.legal_entity = cp_le_id
1853: AND d2.period_year = d1.period_year
1854: AND org.organization_id = d1.organization_id