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.AHL_WBS_RULES_PVT dependencies on AHL_WBS_RULES

Line 1: PACKAGE BODY AHL_WBS_RULES_PVT AS

1: PACKAGE BODY AHL_WBS_RULES_PVT AS
2: /* $Header: AHLVWBSB.pls 120.0.12020000.2 2012/12/11 05:41:09 prakkum noship $ */
3:
4: G_PKG_NAME VARCHAR2(30) := 'AHL_WBS_RULES_PVT';
5: G_DEBUG VARCHAR2(1) := NVL(AHL_DEBUG_PUB.is_log_enabled,'N');

Line 4: G_PKG_NAME VARCHAR2(30) := 'AHL_WBS_RULES_PVT';

1: PACKAGE BODY AHL_WBS_RULES_PVT AS
2: /* $Header: AHLVWBSB.pls 120.0.12020000.2 2012/12/11 05:41:09 prakkum noship $ */
3:
4: G_PKG_NAME VARCHAR2(30) := 'AHL_WBS_RULES_PVT';
5: G_DEBUG VARCHAR2(1) := NVL(AHL_DEBUG_PUB.is_log_enabled,'N');
6:
7: -- constants for WHO Columns
8: G_LAST_UPDATE_DATE DATE := SYSDATE;

Line 130: FROM AHL_WBS_RULES

126:
127: CURSOR CHK_DUP_RULE(c_rule_text VARCHAR2)
128: IS
129: SELECT count(RULE_ID)
130: FROM AHL_WBS_RULES
131: WHERE RULE_TEXT = c_rule_text
132: AND RULE_ID <> p_x_wbs_rules_rec.RULE_ID;
133:
134: L_API_VERSION CONSTANT NUMBER := 1.0;

Line 139: L_PRE_ROUTE AHL_WBS_RULES.PRE_ROUTE_NUMBER%TYPE := p_x_wbs_rules_rec.PRE_ROUTE_NUMBER;

135: L_API_NAME CONSTANT VARCHAR2(30) := 'validate_rule';
136: L_FULL_NAME CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || L_API_NAME;
137: L_DEBUG CONSTANT VARCHAR2(90) := 'ahl.plsql.'||L_FULL_NAME;
138:
139: L_PRE_ROUTE AHL_WBS_RULES.PRE_ROUTE_NUMBER%TYPE := p_x_wbs_rules_rec.PRE_ROUTE_NUMBER;
140: L_PRE_ROUTE_TYPE_CODE AHL_WBS_RULES.PRE_ROUTE_TYPE_CODE%TYPE := p_x_wbs_rules_rec.PRE_ROUTE_TYPE_CODE;
141: L_PRE_SYSTEM_CODE AHL_WBS_RULES.PRE_SYSTEM_CODE%TYPE := p_x_wbs_rules_rec.PRE_SYSTEM_CODE;
142: L_PRE_PROCESS_CODE AHL_WBS_RULES.PRE_PROCESS_CODE%TYPE := p_x_wbs_rules_rec.PRE_PROCESS_CODE;
143: L_POST_ROUTE AHL_WBS_RULES.POST_ROUTE_NUMBER%TYPE := p_x_wbs_rules_rec.POST_ROUTE_NUMBER;

Line 140: L_PRE_ROUTE_TYPE_CODE AHL_WBS_RULES.PRE_ROUTE_TYPE_CODE%TYPE := p_x_wbs_rules_rec.PRE_ROUTE_TYPE_CODE;

136: L_FULL_NAME CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || L_API_NAME;
137: L_DEBUG CONSTANT VARCHAR2(90) := 'ahl.plsql.'||L_FULL_NAME;
138:
139: L_PRE_ROUTE AHL_WBS_RULES.PRE_ROUTE_NUMBER%TYPE := p_x_wbs_rules_rec.PRE_ROUTE_NUMBER;
140: L_PRE_ROUTE_TYPE_CODE AHL_WBS_RULES.PRE_ROUTE_TYPE_CODE%TYPE := p_x_wbs_rules_rec.PRE_ROUTE_TYPE_CODE;
141: L_PRE_SYSTEM_CODE AHL_WBS_RULES.PRE_SYSTEM_CODE%TYPE := p_x_wbs_rules_rec.PRE_SYSTEM_CODE;
142: L_PRE_PROCESS_CODE AHL_WBS_RULES.PRE_PROCESS_CODE%TYPE := p_x_wbs_rules_rec.PRE_PROCESS_CODE;
143: L_POST_ROUTE AHL_WBS_RULES.POST_ROUTE_NUMBER%TYPE := p_x_wbs_rules_rec.POST_ROUTE_NUMBER;
144: L_POST_ROUTE_TYPE_CODE AHL_WBS_RULES.POST_ROUTE_TYPE_CODE%TYPE := p_x_wbs_rules_rec.POST_ROUTE_TYPE_CODE;

Line 141: L_PRE_SYSTEM_CODE AHL_WBS_RULES.PRE_SYSTEM_CODE%TYPE := p_x_wbs_rules_rec.PRE_SYSTEM_CODE;

137: L_DEBUG CONSTANT VARCHAR2(90) := 'ahl.plsql.'||L_FULL_NAME;
138:
139: L_PRE_ROUTE AHL_WBS_RULES.PRE_ROUTE_NUMBER%TYPE := p_x_wbs_rules_rec.PRE_ROUTE_NUMBER;
140: L_PRE_ROUTE_TYPE_CODE AHL_WBS_RULES.PRE_ROUTE_TYPE_CODE%TYPE := p_x_wbs_rules_rec.PRE_ROUTE_TYPE_CODE;
141: L_PRE_SYSTEM_CODE AHL_WBS_RULES.PRE_SYSTEM_CODE%TYPE := p_x_wbs_rules_rec.PRE_SYSTEM_CODE;
142: L_PRE_PROCESS_CODE AHL_WBS_RULES.PRE_PROCESS_CODE%TYPE := p_x_wbs_rules_rec.PRE_PROCESS_CODE;
143: L_POST_ROUTE AHL_WBS_RULES.POST_ROUTE_NUMBER%TYPE := p_x_wbs_rules_rec.POST_ROUTE_NUMBER;
144: L_POST_ROUTE_TYPE_CODE AHL_WBS_RULES.POST_ROUTE_TYPE_CODE%TYPE := p_x_wbs_rules_rec.POST_ROUTE_TYPE_CODE;
145: L_POST_SYSTEM_CODE AHL_WBS_RULES.POST_SYSTEM_CODE%TYPE := p_x_wbs_rules_rec.POST_SYSTEM_CODE;

Line 142: L_PRE_PROCESS_CODE AHL_WBS_RULES.PRE_PROCESS_CODE%TYPE := p_x_wbs_rules_rec.PRE_PROCESS_CODE;

138:
139: L_PRE_ROUTE AHL_WBS_RULES.PRE_ROUTE_NUMBER%TYPE := p_x_wbs_rules_rec.PRE_ROUTE_NUMBER;
140: L_PRE_ROUTE_TYPE_CODE AHL_WBS_RULES.PRE_ROUTE_TYPE_CODE%TYPE := p_x_wbs_rules_rec.PRE_ROUTE_TYPE_CODE;
141: L_PRE_SYSTEM_CODE AHL_WBS_RULES.PRE_SYSTEM_CODE%TYPE := p_x_wbs_rules_rec.PRE_SYSTEM_CODE;
142: L_PRE_PROCESS_CODE AHL_WBS_RULES.PRE_PROCESS_CODE%TYPE := p_x_wbs_rules_rec.PRE_PROCESS_CODE;
143: L_POST_ROUTE AHL_WBS_RULES.POST_ROUTE_NUMBER%TYPE := p_x_wbs_rules_rec.POST_ROUTE_NUMBER;
144: L_POST_ROUTE_TYPE_CODE AHL_WBS_RULES.POST_ROUTE_TYPE_CODE%TYPE := p_x_wbs_rules_rec.POST_ROUTE_TYPE_CODE;
145: L_POST_SYSTEM_CODE AHL_WBS_RULES.POST_SYSTEM_CODE%TYPE := p_x_wbs_rules_rec.POST_SYSTEM_CODE;
146: L_POST_PROCESS_CODE AHL_WBS_RULES.POST_PROCESS_CODE%TYPE := p_x_wbs_rules_rec.POST_PROCESS_CODE;

Line 143: L_POST_ROUTE AHL_WBS_RULES.POST_ROUTE_NUMBER%TYPE := p_x_wbs_rules_rec.POST_ROUTE_NUMBER;

139: L_PRE_ROUTE AHL_WBS_RULES.PRE_ROUTE_NUMBER%TYPE := p_x_wbs_rules_rec.PRE_ROUTE_NUMBER;
140: L_PRE_ROUTE_TYPE_CODE AHL_WBS_RULES.PRE_ROUTE_TYPE_CODE%TYPE := p_x_wbs_rules_rec.PRE_ROUTE_TYPE_CODE;
141: L_PRE_SYSTEM_CODE AHL_WBS_RULES.PRE_SYSTEM_CODE%TYPE := p_x_wbs_rules_rec.PRE_SYSTEM_CODE;
142: L_PRE_PROCESS_CODE AHL_WBS_RULES.PRE_PROCESS_CODE%TYPE := p_x_wbs_rules_rec.PRE_PROCESS_CODE;
143: L_POST_ROUTE AHL_WBS_RULES.POST_ROUTE_NUMBER%TYPE := p_x_wbs_rules_rec.POST_ROUTE_NUMBER;
144: L_POST_ROUTE_TYPE_CODE AHL_WBS_RULES.POST_ROUTE_TYPE_CODE%TYPE := p_x_wbs_rules_rec.POST_ROUTE_TYPE_CODE;
145: L_POST_SYSTEM_CODE AHL_WBS_RULES.POST_SYSTEM_CODE%TYPE := p_x_wbs_rules_rec.POST_SYSTEM_CODE;
146: L_POST_PROCESS_CODE AHL_WBS_RULES.POST_PROCESS_CODE%TYPE := p_x_wbs_rules_rec.POST_PROCESS_CODE;
147: L_PRE_ROUTE_TYPE_MEANING VARCHAR2(80) := p_x_wbs_rules_rec.PRE_ROUTE_TYPE_MEANING;

Line 144: L_POST_ROUTE_TYPE_CODE AHL_WBS_RULES.POST_ROUTE_TYPE_CODE%TYPE := p_x_wbs_rules_rec.POST_ROUTE_TYPE_CODE;

140: L_PRE_ROUTE_TYPE_CODE AHL_WBS_RULES.PRE_ROUTE_TYPE_CODE%TYPE := p_x_wbs_rules_rec.PRE_ROUTE_TYPE_CODE;
141: L_PRE_SYSTEM_CODE AHL_WBS_RULES.PRE_SYSTEM_CODE%TYPE := p_x_wbs_rules_rec.PRE_SYSTEM_CODE;
142: L_PRE_PROCESS_CODE AHL_WBS_RULES.PRE_PROCESS_CODE%TYPE := p_x_wbs_rules_rec.PRE_PROCESS_CODE;
143: L_POST_ROUTE AHL_WBS_RULES.POST_ROUTE_NUMBER%TYPE := p_x_wbs_rules_rec.POST_ROUTE_NUMBER;
144: L_POST_ROUTE_TYPE_CODE AHL_WBS_RULES.POST_ROUTE_TYPE_CODE%TYPE := p_x_wbs_rules_rec.POST_ROUTE_TYPE_CODE;
145: L_POST_SYSTEM_CODE AHL_WBS_RULES.POST_SYSTEM_CODE%TYPE := p_x_wbs_rules_rec.POST_SYSTEM_CODE;
146: L_POST_PROCESS_CODE AHL_WBS_RULES.POST_PROCESS_CODE%TYPE := p_x_wbs_rules_rec.POST_PROCESS_CODE;
147: L_PRE_ROUTE_TYPE_MEANING VARCHAR2(80) := p_x_wbs_rules_rec.PRE_ROUTE_TYPE_MEANING;
148: L_PRE_PROCESS_MEANING VARCHAR2(80) := p_x_wbs_rules_rec.PRE_PROCESS_MEANING;

Line 145: L_POST_SYSTEM_CODE AHL_WBS_RULES.POST_SYSTEM_CODE%TYPE := p_x_wbs_rules_rec.POST_SYSTEM_CODE;

141: L_PRE_SYSTEM_CODE AHL_WBS_RULES.PRE_SYSTEM_CODE%TYPE := p_x_wbs_rules_rec.PRE_SYSTEM_CODE;
142: L_PRE_PROCESS_CODE AHL_WBS_RULES.PRE_PROCESS_CODE%TYPE := p_x_wbs_rules_rec.PRE_PROCESS_CODE;
143: L_POST_ROUTE AHL_WBS_RULES.POST_ROUTE_NUMBER%TYPE := p_x_wbs_rules_rec.POST_ROUTE_NUMBER;
144: L_POST_ROUTE_TYPE_CODE AHL_WBS_RULES.POST_ROUTE_TYPE_CODE%TYPE := p_x_wbs_rules_rec.POST_ROUTE_TYPE_CODE;
145: L_POST_SYSTEM_CODE AHL_WBS_RULES.POST_SYSTEM_CODE%TYPE := p_x_wbs_rules_rec.POST_SYSTEM_CODE;
146: L_POST_PROCESS_CODE AHL_WBS_RULES.POST_PROCESS_CODE%TYPE := p_x_wbs_rules_rec.POST_PROCESS_CODE;
147: L_PRE_ROUTE_TYPE_MEANING VARCHAR2(80) := p_x_wbs_rules_rec.PRE_ROUTE_TYPE_MEANING;
148: L_PRE_PROCESS_MEANING VARCHAR2(80) := p_x_wbs_rules_rec.PRE_PROCESS_MEANING;
149: L_POST_ROUTE_TYPE_MEANING VARCHAR2(80) := p_x_wbs_rules_rec.POST_ROUTE_TYPE_MEANING;

Line 146: L_POST_PROCESS_CODE AHL_WBS_RULES.POST_PROCESS_CODE%TYPE := p_x_wbs_rules_rec.POST_PROCESS_CODE;

142: L_PRE_PROCESS_CODE AHL_WBS_RULES.PRE_PROCESS_CODE%TYPE := p_x_wbs_rules_rec.PRE_PROCESS_CODE;
143: L_POST_ROUTE AHL_WBS_RULES.POST_ROUTE_NUMBER%TYPE := p_x_wbs_rules_rec.POST_ROUTE_NUMBER;
144: L_POST_ROUTE_TYPE_CODE AHL_WBS_RULES.POST_ROUTE_TYPE_CODE%TYPE := p_x_wbs_rules_rec.POST_ROUTE_TYPE_CODE;
145: L_POST_SYSTEM_CODE AHL_WBS_RULES.POST_SYSTEM_CODE%TYPE := p_x_wbs_rules_rec.POST_SYSTEM_CODE;
146: L_POST_PROCESS_CODE AHL_WBS_RULES.POST_PROCESS_CODE%TYPE := p_x_wbs_rules_rec.POST_PROCESS_CODE;
147: L_PRE_ROUTE_TYPE_MEANING VARCHAR2(80) := p_x_wbs_rules_rec.PRE_ROUTE_TYPE_MEANING;
148: L_PRE_PROCESS_MEANING VARCHAR2(80) := p_x_wbs_rules_rec.PRE_PROCESS_MEANING;
149: L_POST_ROUTE_TYPE_MEANING VARCHAR2(80) := p_x_wbs_rules_rec.POST_ROUTE_TYPE_MEANING;
150: L_POST_PROCESS_MEANING VARCHAR2(80) := p_x_wbs_rules_rec.POST_PROCESS_MEANING;

Line 429: FROM ahl_wbs_rules

425:
426: BEGIN
427:
428: SELECT COUNT(*) INTO l_counter
429: FROM ahl_wbs_rules
430: START WITH POST_ROUTE_NUMBER = p_x_wbs_rules_rec.PRE_ROUTE_NUMBER
431: CONNECT BY PRIOR PRE_ROUTE_NUMBER = POST_ROUTE_NUMBER;
432:
433: EXCEPTION

Line 519: INSERT INTO AHL_WBS_RULES

515: IF (l_log_statement >= l_log_current_level) THEN
516: FND_LOG.string(l_log_statement, L_DEBUG, 'rule_id-' || p_x_wbs_rules_rec.rule_id || ': About to insert rule');
517: END IF;
518:
519: INSERT INTO AHL_WBS_RULES
520: (
521: RULE_ID,
522: OBJECT_VERSION_NUMBER,
523: LAST_UPDATE_DATE,

Line 685: UPDATE AHL_WBS_RULES

681: IF (l_log_statement >= l_log_current_level) THEN
682: FND_LOG.string(l_log_statement, L_DEBUG, 'rule_id-' || p_x_wbs_rules_rec.rule_id || ': About to update rule');
683: END IF;
684:
685: UPDATE AHL_WBS_RULES
686: SET OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
687: LAST_UPDATE_DATE = G_LAST_UPDATE_DATE,
688: LAST_UPDATED_BY = G_LAST_UPDATED_BY,
689: LAST_UPDATE_LOGIN = G_LAST_UPDATE_LOGIN,

Line 766: END AHL_WBS_RULES_PVT;

762: END IF;
763: END update_rule;
764:
765:
766: END AHL_WBS_RULES_PVT;