APPS.GMICCAL dependencies on IC_CLDR_DTL

Line 20: ic_cldr_dtl.orgn_code%TYPE;

16:
17: trans_date - transaction date in format
18: dd-mmm-yyyy hh24:mi:ss
19: porgn_code - organization code of type
20: ic_cldr_dtl.orgn_code%TYPE;
21: pwhse_code - warehouse code of type
22: ic_whse_mst.whse_code%TYPE;
23:
24: RETURNS:

Line 58: l_fiscal_yr ic_cldr_dtl.fiscal_year%TYPE;

54: /* Variable Declarations
55: ===================== */
56: l_period_date enddate_type;
57: l_begin_date enddate_type;
58: l_fiscal_yr ic_cldr_dtl.fiscal_year%TYPE;
59: l_period_ind ic_cldr_dtl.closed_period_ind%TYPE;
60: l_period ic_cldr_dtl.period%TYPE;
61: lp_co_code orgn_type;
62: lp_orgn_code orgn_type;

Line 59: l_period_ind ic_cldr_dtl.closed_period_ind%TYPE;

55: ===================== */
56: l_period_date enddate_type;
57: l_begin_date enddate_type;
58: l_fiscal_yr ic_cldr_dtl.fiscal_year%TYPE;
59: l_period_ind ic_cldr_dtl.closed_period_ind%TYPE;
60: l_period ic_cldr_dtl.period%TYPE;
61: lp_co_code orgn_type;
62: lp_orgn_code orgn_type;
63: l_whse_code whse_type;

Line 60: l_period ic_cldr_dtl.period%TYPE;

56: l_period_date enddate_type;
57: l_begin_date enddate_type;
58: l_fiscal_yr ic_cldr_dtl.fiscal_year%TYPE;
59: l_period_ind ic_cldr_dtl.closed_period_ind%TYPE;
60: l_period ic_cldr_dtl.period%TYPE;
61: lp_co_code orgn_type;
62: lp_orgn_code orgn_type;
63: l_whse_code whse_type;
64: iret NUMBER;

Line 84: FROM ic_cldr_dtl

80: AND orgn_code = UPPER(lp_co_code);
81:
82: CURSOR get_period_date IS
83: SELECT MIN(Period_end_date)
84: FROM ic_cldr_dtl
85: WHERE TRUNC(period_end_date, 'DD') >=
86: TRUNC(trans_date, 'DD')
87: AND fiscal_year = l_fiscal_yr
88: AND UPPER(orgn_code) = UPPER(lp_co_code);

Line 92: FROM ic_cldr_dtl

88: AND UPPER(orgn_code) = UPPER(lp_co_code);
89:
90: CURSOR get_period_info IS
91: SELECT closed_period_ind, period
92: FROM ic_cldr_dtl
93: WHERE fiscal_year = l_fiscal_yr
94: AND period_end_date = l_period_date
95: AND UPPER(orgn_code) = UPPER(lp_co_code);
96:

Line 813: UPDATE ic_cldr_dtl

809: END IF;
810: CLOSE determine_type;
811:
812:
813: UPDATE ic_cldr_dtl
814: SET closed_period_ind = l_close_type,
815: last_update_date = SYSDATE
816: WHERE orgn_code = pco_code
817: AND fiscal_year = pfiscal_year

Line 846: ic_cldr_dtl.orgn_code%TYPE;

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;
847: porgn_code - will hold the company code of type
848: ic_cldr_dtl.orgn_code%TYPE;
849:
850:

Line 848: ic_cldr_dtl.orgn_code%TYPE;

844:
845: porgn_code - organization code of type
846: ic_cldr_dtl.orgn_code%TYPE;
847: porgn_code - will hold the company code of type
848: ic_cldr_dtl.orgn_code%TYPE;
849:
850:
851: RETURNS:
852: 0 Success