DBA Data[Home] [Help]

APPS.GMICCAL dependencies on GMICCAL

Line 1: PACKAGE BODY GMICCAL AS

1: PACKAGE BODY GMICCAL AS
2: /* $Header: gmiccalb.pls 115.10 2003/03/21 14:32:30 jdiiorio ship $ */
3: /* =============================================
4: FUNCTION:
5: trans_date_validate

Line 2: /* $Header: gmiccalb.pls 115.10 2003/03/21 14:32:30 jdiiorio ship $ */

1: PACKAGE BODY GMICCAL AS
2: /* $Header: gmiccalb.pls 115.10 2003/03/21 14:32:30 jdiiorio ship $ */
3: /* =============================================
4: FUNCTION:
5: trans_date_validate
6:

Line 14: iret := GMICCAL.trans_date_validate(trans_date, porgn_code,

10: valid inventory calendar period based on
11: the organization code passed in.
12:
13: SYNOPSIS:
14: iret := GMICCAL.trans_date_validate(trans_date, porgn_code,
15: pwhse_code);
16:
17: trans_date - transaction date in format
18: dd-mmm-yyyy hh24:mi:ss

Line 169: iret := GMICCAL.determine_company(lp_orgn_code, lp_co_code);

165: code of organization which owns the whse.
166: This calls the determine_company() function
167: ======================================= */
168:
169: iret := GMICCAL.determine_company(lp_orgn_code, lp_co_code);
170: IF(iret <> 0) THEN
171: RETURN INVCAL_CO_ERR;
172:
173: END IF;

Line 319: iret := GMICCAL.delete_ic_perd_bal(pfiscal_yr, pperiod,

315: deleting rows from the ic_perd_bal in conjuction
316: with the rerunning of a preliminary close.
317:
318: SYNOPSIS:
319: iret := GMICCAL.delete_ic_perd_bal(pfiscal_yr, pperiod,
320: pwhse_code);
321:
322: pfiscal_yr - The fiscal year for the Calendar.
323: pperiod - The period within the Fiscal year.

Line 371: iret := GMICCAL.insert_ic_perd_bal(pwhse_code);

367: with the running of a preliminary or Final close.
368: This is the initial seeding of this table.
369:
370: SYNOPSIS:
371: iret := GMICCAL.insert_ic_perd_bal(pwhse_code);
372:
373: pfiscal_year - Fiscal Year of Calendar.
374: pper_id - Period ID surrogate of period within
375: calendar.

Line 431: iret := GMICCAL.calc_usage_yield(pwhse_code, pprd_start_date,

427: This function is called from both the
428: preliminary and final CLOSE process.
429:
430: SYNOPSIS:
431: iret := GMICCAL.calc_usage_yield(pwhse_code, pprd_start_date,
432: pprd_end_date, plog_end_date, pperiod,
433: pfiscal_year, pop_code);
434:
435: pwhse_code - warehouse code

Line 700: iret := GMICCAL.whse_status_update(pwhse_code,

696: as the result of either an inventory calendar
697: preliminary or final close of a warehouse.
698:
699: SYNOPSIS:
700: iret := GMICCAL.whse_status_update(pwhse_code,
701: pperiod, pclose_type);
702:
703: pwhse_code - warehouse which has been preliminary
704: or final closed.

Line 762: iret := GMICCAL.period_status_update(pco_code,

758: as the result of either an inventory calendar
759: preliminary or final close of a warehouse.
760:
761: SYNOPSIS:
762: iret := GMICCAL.period_status_update(pco_code,
763: pfiscal_year, pperiod, pclose_type);
764:
765: pco_code - The company for the Inventory Calendar.
766: pfiscal_year- The fiscal year of the Calendar.

Line 842: iret := GMICCAL.determine_company(porgn_code,

838: determining the company associated to the
839: passed in organization code.
840:
841: SYNOPSIS:
842: iret := GMICCAL.determine_company(porgn_code,
843: pout_orgn_code);
844:
845: porgn_code - organization code of type
846: ic_cldr_dtl.orgn_code%TYPE;