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.DDR_POP_CALENDAR_PKG dependencies on DDR_R_ORG

Line 146: from DDR_R_ORG

142: RETURN VARCHAR2
143: IS
144: cursor cur_org is
145: select ORG_TYP
146: from DDR_R_ORG
147: where ORG_CD = p_org_code;
148:
149: l_org_type DDR_R_ORG.ORG_TYP%TYPE;
150: BEGIN

Line 149: l_org_type DDR_R_ORG.ORG_TYP%TYPE;

145: select ORG_TYP
146: from DDR_R_ORG
147: where ORG_CD = p_org_code;
148:
149: l_org_type DDR_R_ORG.ORG_TYP%TYPE;
150: BEGIN
151: OPEN cur_org;
152: FETCH cur_org INTO l_org_type;
153: IF cur_org%NOTFOUND

Line 166: from DDR_R_ORG

162: RETURN VARCHAR2
163: IS
164: cursor cur_mfg is
165: select ORG_CD
166: from DDR_R_ORG
167: where ORG_TYP = 'MFG';
168:
169: l_mfg_code DDR_R_ORG.ORG_CD%TYPE;
170: BEGIN

Line 169: l_mfg_code DDR_R_ORG.ORG_CD%TYPE;

165: select ORG_CD
166: from DDR_R_ORG
167: where ORG_TYP = 'MFG';
168:
169: l_mfg_code DDR_R_ORG.ORG_CD%TYPE;
170: BEGIN
171: OPEN cur_mfg;
172: FETCH cur_mfg INTO l_mfg_code;
173: IF cur_mfg%NOTFOUND

Line 1139: l_org_type DDR_R_ORG.ORG_TYP%TYPE;

1135: l_last_year NUMBER;
1136: l_last_year_start_date DATE;
1137: l_last_year_end_date DATE;
1138:
1139: l_org_type DDR_R_ORG.ORG_TYP%TYPE;
1140: l_mfg_org_cd DDR_R_ORG.ORG_CD%TYPE;
1141: l_clndr_cd DDR_R_CLNDR.CLNDR_CD%TYPE;
1142: l_missing_year VARCHAR2(100);
1143:

Line 1140: l_mfg_org_cd DDR_R_ORG.ORG_CD%TYPE;

1136: l_last_year_start_date DATE;
1137: l_last_year_end_date DATE;
1138:
1139: l_org_type DDR_R_ORG.ORG_TYP%TYPE;
1140: l_mfg_org_cd DDR_R_ORG.ORG_CD%TYPE;
1141: l_clndr_cd DDR_R_CLNDR.CLNDR_CD%TYPE;
1142: l_missing_year VARCHAR2(100);
1143:
1144: l_spl_year_flag BOOLEAN := FALSE;

Line 1177: Validate that p_org_cd is not null and also it is a valid organization as per DDR_R_ORG table

1173: l_qtr_idx_name VARCHAR2(30);
1174: l_month_idx_name VARCHAR2(30);
1175: BEGIN
1176: /*
1177: Validate that p_org_cd is not null and also it is a valid organization as per DDR_R_ORG table
1178: Check that Organization Type in ('MFG','RTL')
1179: */
1180: IF p_org_cd IS NULL
1181: THEN

Line 1196: /* Validate that Manufacturing Organization exists in DDR_R_ORG */

1192: THEN
1193: Raise_Error('Business Calendar can be defined for Manufacturer, Retailer and Distributor only');
1194: END IF;
1195:
1196: /* Validate that Manufacturing Organization exists in DDR_R_ORG */
1197: l_mfg_org_cd := Get_Manufacturer;
1198: IF (l_org_type <> 'MFG') AND (l_mfg_org_cd IS NULL)
1199: THEN
1200: Raise_Error('Manufacturer Organization not yet defined');

Line 1599: l_org_type DDR_R_ORG.ORG_TYP%TYPE;

1595: l_last_year NUMBER;
1596: l_last_year_start_date DATE;
1597: l_last_year_end_date DATE;
1598:
1599: l_org_type DDR_R_ORG.ORG_TYP%TYPE;
1600: l_mfg_org_cd DDR_R_ORG.ORG_CD%TYPE;
1601: l_clndr_cd DDR_R_CLNDR.CLNDR_CD%TYPE;
1602: l_missing_year VARCHAR2(100);
1603:

Line 1600: l_mfg_org_cd DDR_R_ORG.ORG_CD%TYPE;

1596: l_last_year_start_date DATE;
1597: l_last_year_end_date DATE;
1598:
1599: l_org_type DDR_R_ORG.ORG_TYP%TYPE;
1600: l_mfg_org_cd DDR_R_ORG.ORG_CD%TYPE;
1601: l_clndr_cd DDR_R_CLNDR.CLNDR_CD%TYPE;
1602: l_missing_year VARCHAR2(100);
1603:
1604: l_no_of_years NUMBER;

Line 1626: Validate that p_org_cd is not null and also it is a valid organization as per DDR_R_ORG table

1622: l_month_no NUMBER;
1623: l_day_no NUMBER;
1624: BEGIN
1625: /*
1626: Validate that p_org_cd is not null and also it is a valid organization as per DDR_R_ORG table
1627: Check that Organization Type in ('MFG')
1628: */
1629: IF p_org_cd IS NULL
1630: THEN

Line 1948: l_org_type DDR_R_ORG.ORG_TYP%TYPE;

1944: l_last_year NUMBER;
1945: l_last_year_start_date DATE;
1946: l_last_year_end_date DATE;
1947:
1948: l_org_type DDR_R_ORG.ORG_TYP%TYPE;
1949: l_mfg_org_cd DDR_R_ORG.ORG_CD%TYPE;
1950: l_clndr_cd DDR_R_CLNDR.CLNDR_CD%TYPE;
1951: l_missing_year VARCHAR2(100);
1952:

Line 1949: l_mfg_org_cd DDR_R_ORG.ORG_CD%TYPE;

1945: l_last_year_start_date DATE;
1946: l_last_year_end_date DATE;
1947:
1948: l_org_type DDR_R_ORG.ORG_TYP%TYPE;
1949: l_mfg_org_cd DDR_R_ORG.ORG_CD%TYPE;
1950: l_clndr_cd DDR_R_CLNDR.CLNDR_CD%TYPE;
1951: l_missing_year VARCHAR2(100);
1952:
1953: l_spl_year_flag BOOLEAN := FALSE;

Line 1989: Validate that p_org_cd is not null and also it is a valid organization as per DDR_R_ORG table

1985: l_spcl_qtr VARCHAR2(30);
1986: -- Bug# 6965786 change end
1987: BEGIN
1988: /*
1989: Validate that p_org_cd is not null and also it is a valid organization as per DDR_R_ORG table
1990: Check that Organization Type in ('MFG','RTL')
1991: */
1992: IF p_org_cd IS NULL
1993: THEN

Line 2412: l_org_type DDR_R_ORG.ORG_TYP%TYPE;

2408: l_last_year NUMBER;
2409: l_last_year_start_date DATE;
2410: l_last_year_end_date DATE;
2411:
2412: l_org_type DDR_R_ORG.ORG_TYP%TYPE;
2413: l_mfg_org_cd DDR_R_ORG.ORG_CD%TYPE;
2414: l_clndr_cd DDR_R_CLNDR.CLNDR_CD%TYPE;
2415: l_missing_year VARCHAR2(100);
2416:

Line 2413: l_mfg_org_cd DDR_R_ORG.ORG_CD%TYPE;

2409: l_last_year_start_date DATE;
2410: l_last_year_end_date DATE;
2411:
2412: l_org_type DDR_R_ORG.ORG_TYP%TYPE;
2413: l_mfg_org_cd DDR_R_ORG.ORG_CD%TYPE;
2414: l_clndr_cd DDR_R_CLNDR.CLNDR_CD%TYPE;
2415: l_missing_year VARCHAR2(100);
2416:
2417: l_spl_year_flag BOOLEAN := FALSE;

Line 2453: Validate that p_org_cd is not null and also it is a valid organization as per DDR_R_ORG table

2449: l_spcl_qtr VARCHAR2(30);
2450: -- Bug# 6965786 change end
2451: BEGIN
2452: /*
2453: Validate that p_org_cd is not null and also it is a valid organization as per DDR_R_ORG table
2454: Check that Organization Type in ('MFG','RTL')
2455: */
2456: IF p_org_cd IS NULL
2457: THEN