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.CN_CHK_PLAN_ELEMENT_PKG dependencies on FND_LOOKUPS

Line 575: l_yes fnd_lookups.meaning%TYPE;

571: x_loading_status OUT NOCOPY VARCHAR2
572: )
573: IS
574: l_api_name CONSTANT VARCHAR2 (30) := 'chk_dr_man_pe';
575: l_yes fnd_lookups.meaning%TYPE;
576: l_no fnd_lookups.meaning%TYPE;
577: BEGIN
578: /* x_return_status := FND_API.G_RET_STS_SUCCESS;
579: x_loading_status := p_loading_status;

Line 576: l_no fnd_lookups.meaning%TYPE;

572: )
573: IS
574: l_api_name CONSTANT VARCHAR2 (30) := 'chk_dr_man_pe';
575: l_yes fnd_lookups.meaning%TYPE;
576: l_no fnd_lookups.meaning%TYPE;
577: BEGIN
578: /* x_return_status := FND_API.G_RET_STS_SUCCESS;
579: x_loading_status := p_loading_status;
580:

Line 581: SELECT meaning INTO l_yes FROM fnd_lookups

577: BEGIN
578: /* x_return_status := FND_API.G_RET_STS_SUCCESS;
579: x_loading_status := p_loading_status;
580:
581: SELECT meaning INTO l_yes FROM fnd_lookups
582: WHERE lookup_code = 'Y' AND lookup_type = 'YES_NO';
583: SELECT meaning INTO l_no FROM fnd_lookups
584: WHERE lookup_code = 'N' AND lookup_type = 'YES_NO';
585: --+

Line 583: SELECT meaning INTO l_no FROM fnd_lookups

579: x_loading_status := p_loading_status;
580:
581: SELECT meaning INTO l_yes FROM fnd_lookups
582: WHERE lookup_code = 'Y' AND lookup_type = 'YES_NO';
583: SELECT meaning INTO l_no FROM fnd_lookups
584: WHERE lookup_code = 'N' AND lookup_type = 'YES_NO';
585: --+
586: -- Validate Rule :
587: -- trx_group_code = NULL, payment_type_code=NULL, disc_option_code =NONE

Line 793: l_yes fnd_lookups.meaning%TYPE;

789: x_loading_status OUT NOCOPY VARCHAR2
790: )
791: IS
792: l_api_name CONSTANT VARCHAR2 (30) := 'chk_revenue_quota_pe';
793: l_yes fnd_lookups.meaning%TYPE;
794: l_no fnd_lookups.meaning%TYPE;
795: BEGIN
796: /* x_return_status := FND_API.G_RET_STS_SUCCESS;
797: x_loading_status := p_loading_status;

Line 794: l_no fnd_lookups.meaning%TYPE;

790: )
791: IS
792: l_api_name CONSTANT VARCHAR2 (30) := 'chk_revenue_quota_pe';
793: l_yes fnd_lookups.meaning%TYPE;
794: l_no fnd_lookups.meaning%TYPE;
795: BEGIN
796: /* x_return_status := FND_API.G_RET_STS_SUCCESS;
797: x_loading_status := p_loading_status;
798:

Line 799: SELECT meaning INTO l_yes FROM fnd_lookups

795: BEGIN
796: /* x_return_status := FND_API.G_RET_STS_SUCCESS;
797: x_loading_status := p_loading_status;
798:
799: SELECT meaning INTO l_yes FROM fnd_lookups
800: WHERE lookup_code = 'Y' AND lookup_type = 'YES_NO';
801: SELECT meaning INTO l_no FROM fnd_lookups
802: WHERE lookup_code = 'N' AND lookup_type = 'YES_NO';
803:

Line 801: SELECT meaning INTO l_no FROM fnd_lookups

797: x_loading_status := p_loading_status;
798:
799: SELECT meaning INTO l_yes FROM fnd_lookups
800: WHERE lookup_code = 'Y' AND lookup_type = 'YES_NO';
801: SELECT meaning INTO l_no FROM fnd_lookups
802: WHERE lookup_code = 'N' AND lookup_type = 'YES_NO';
803:
804: --+
805: -- Validate Rule : cumulative flag Y only

Line 1175: l_yes fnd_lookups.meaning%TYPE;

1171: x_loading_status OUT NOCOPY VARCHAR2
1172: )
1173: IS
1174: l_api_name CONSTANT VARCHAR2 (30) := 'chk_unit_quota_pe';
1175: l_yes fnd_lookups.meaning%TYPE;
1176: l_no fnd_lookups.meaning%TYPE;
1177: BEGIN
1178: /* x_return_status := FND_API.G_RET_STS_SUCCESS;
1179: x_loading_status := p_loading_status;

Line 1176: l_no fnd_lookups.meaning%TYPE;

1172: )
1173: IS
1174: l_api_name CONSTANT VARCHAR2 (30) := 'chk_unit_quota_pe';
1175: l_yes fnd_lookups.meaning%TYPE;
1176: l_no fnd_lookups.meaning%TYPE;
1177: BEGIN
1178: /* x_return_status := FND_API.G_RET_STS_SUCCESS;
1179: x_loading_status := p_loading_status;
1180:

Line 1181: SELECT meaning INTO l_yes FROM fnd_lookups

1177: BEGIN
1178: /* x_return_status := FND_API.G_RET_STS_SUCCESS;
1179: x_loading_status := p_loading_status;
1180:
1181: SELECT meaning INTO l_yes FROM fnd_lookups
1182: WHERE lookup_code = 'Y' AND lookup_type = 'YES_NO';
1183: SELECT meaning INTO l_no FROM fnd_lookups
1184: WHERE lookup_code = 'N' AND lookup_type = 'YES_NO';
1185: --+

Line 1183: SELECT meaning INTO l_no FROM fnd_lookups

1179: x_loading_status := p_loading_status;
1180:
1181: SELECT meaning INTO l_yes FROM fnd_lookups
1182: WHERE lookup_code = 'Y' AND lookup_type = 'YES_NO';
1183: SELECT meaning INTO l_no FROM fnd_lookups
1184: WHERE lookup_code = 'N' AND lookup_type = 'YES_NO';
1185: --+
1186: -- Validate Rule : cumulative flag Y only
1187: --+

Line 1544: l_yes fnd_lookups.meaning%TYPE;

1540: x_loading_status OUT NOCOPY VARCHAR2
1541: )
1542: IS
1543: l_api_name CONSTANT VARCHAR2 (30) := 'chk_revenue_non_quota_pe';
1544: l_yes fnd_lookups.meaning%TYPE;
1545: l_no fnd_lookups.meaning%TYPE;
1546: BEGIN
1547: /* x_return_status := FND_API.G_RET_STS_SUCCESS;
1548: x_loading_status := p_loading_status;

Line 1545: l_no fnd_lookups.meaning%TYPE;

1541: )
1542: IS
1543: l_api_name CONSTANT VARCHAR2 (30) := 'chk_revenue_non_quota_pe';
1544: l_yes fnd_lookups.meaning%TYPE;
1545: l_no fnd_lookups.meaning%TYPE;
1546: BEGIN
1547: /* x_return_status := FND_API.G_RET_STS_SUCCESS;
1548: x_loading_status := p_loading_status;
1549:

Line 1550: SELECT meaning INTO l_yes FROM fnd_lookups

1546: BEGIN
1547: /* x_return_status := FND_API.G_RET_STS_SUCCESS;
1548: x_loading_status := p_loading_status;
1549:
1550: SELECT meaning INTO l_yes FROM fnd_lookups
1551: WHERE lookup_code = 'Y' AND lookup_type = 'YES_NO';
1552: SELECT meaning INTO l_no FROM fnd_lookups
1553: WHERE lookup_code = 'N' AND lookup_type = 'YES_NO';
1554: --+

Line 1552: SELECT meaning INTO l_no FROM fnd_lookups

1548: x_loading_status := p_loading_status;
1549:
1550: SELECT meaning INTO l_yes FROM fnd_lookups
1551: WHERE lookup_code = 'Y' AND lookup_type = 'YES_NO';
1552: SELECT meaning INTO l_no FROM fnd_lookups
1553: WHERE lookup_code = 'N' AND lookup_type = 'YES_NO';
1554: --+
1555: -- Validate Rule :
1556: -- target = 0, ITD Flag = N

Line 1884: l_yes fnd_lookups.meaning%TYPE;

1880: x_loading_status OUT NOCOPY VARCHAR2
1881: )
1882: IS
1883: l_api_name CONSTANT VARCHAR2 (30) := 'chk_unit_non_quota_pe';
1884: l_yes fnd_lookups.meaning%TYPE;
1885: l_no fnd_lookups.meaning%TYPE;
1886: BEGIN
1887: /* x_return_status := FND_API.G_RET_STS_SUCCESS;
1888: x_loading_status := p_loading_status;

Line 1885: l_no fnd_lookups.meaning%TYPE;

1881: )
1882: IS
1883: l_api_name CONSTANT VARCHAR2 (30) := 'chk_unit_non_quota_pe';
1884: l_yes fnd_lookups.meaning%TYPE;
1885: l_no fnd_lookups.meaning%TYPE;
1886: BEGIN
1887: /* x_return_status := FND_API.G_RET_STS_SUCCESS;
1888: x_loading_status := p_loading_status;
1889:

Line 1890: SELECT meaning INTO l_yes FROM fnd_lookups

1886: BEGIN
1887: /* x_return_status := FND_API.G_RET_STS_SUCCESS;
1888: x_loading_status := p_loading_status;
1889:
1890: SELECT meaning INTO l_yes FROM fnd_lookups
1891: WHERE lookup_code = 'Y' AND lookup_type = 'YES_NO';
1892: SELECT meaning INTO l_no FROM fnd_lookups
1893: WHERE lookup_code = 'N' AND lookup_type = 'YES_NO';
1894: --+

Line 1892: SELECT meaning INTO l_no FROM fnd_lookups

1888: x_loading_status := p_loading_status;
1889:
1890: SELECT meaning INTO l_yes FROM fnd_lookups
1891: WHERE lookup_code = 'Y' AND lookup_type = 'YES_NO';
1892: SELECT meaning INTO l_no FROM fnd_lookups
1893: WHERE lookup_code = 'N' AND lookup_type = 'YES_NO';
1894: --+
1895: -- Validate Rule :
1896: -- target = 0, ITD Flag = N

Line 2214: l_yes fnd_lookups.meaning%TYPE;

2210: x_loading_status OUT NOCOPY VARCHAR2
2211: )
2212: IS
2213: l_api_name CONSTANT VARCHAR2 (30) := 'chk_disc_margin_pe';
2214: l_yes fnd_lookups.meaning%TYPE;
2215: l_no fnd_lookups.meaning%TYPE;
2216: BEGIN
2217: /* x_return_status := FND_API.G_RET_STS_SUCCESS;
2218: x_loading_status := p_loading_status;

Line 2215: l_no fnd_lookups.meaning%TYPE;

2211: )
2212: IS
2213: l_api_name CONSTANT VARCHAR2 (30) := 'chk_disc_margin_pe';
2214: l_yes fnd_lookups.meaning%TYPE;
2215: l_no fnd_lookups.meaning%TYPE;
2216: BEGIN
2217: /* x_return_status := FND_API.G_RET_STS_SUCCESS;
2218: x_loading_status := p_loading_status;
2219:

Line 2220: SELECT meaning INTO l_yes FROM fnd_lookups

2216: BEGIN
2217: /* x_return_status := FND_API.G_RET_STS_SUCCESS;
2218: x_loading_status := p_loading_status;
2219:
2220: SELECT meaning INTO l_yes FROM fnd_lookups
2221: WHERE lookup_code = 'Y' AND lookup_type = 'YES_NO';
2222: SELECT meaning INTO l_no FROM fnd_lookups
2223: WHERE lookup_code = 'N' AND lookup_type = 'YES_NO';
2224: --+

Line 2222: SELECT meaning INTO l_no FROM fnd_lookups

2218: x_loading_status := p_loading_status;
2219:
2220: SELECT meaning INTO l_yes FROM fnd_lookups
2221: WHERE lookup_code = 'Y' AND lookup_type = 'YES_NO';
2222: SELECT meaning INTO l_no FROM fnd_lookups
2223: WHERE lookup_code = 'N' AND lookup_type = 'YES_NO';
2224: --+
2225: -- Validate Rule :
2226: -- target = 0