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.AS_OPP_HEADER_PVT dependencies on AS_LOOKUPS

Line 3538: FROM as_lookups

3534: IS
3535: CURSOR C_CLOSE_REASON_Exists (c_lookup_type VARCHAR2,
3536: c_CLOSE_REASON VARCHAR2) IS
3537: SELECT 'X'
3538: FROM as_lookups
3539: WHERE lookup_type = c_lookup_type
3540: and lookup_code = c_CLOSE_REASON;
3541: -- and enabled_flag = 'Y';
3542:

Line 3561: -- CLOSE_REASON should exist in as_lookups

3557:
3558: IF (p_CLOSE_REASON is NOT NULL) and
3559: (p_CLOSE_REASON <> FND_API.G_MISS_CHAR)
3560: THEN
3561: -- CLOSE_REASON should exist in as_lookups
3562: OPEN C_CLOSE_REASON_Exists ('CLOSE_REASON', p_CLOSE_REASON);
3563: FETCH C_CLOSE_REASON_Exists into l_val;
3564:
3565: IF C_CLOSE_REASON_Exists%NOTFOUND THEN

Line 3790: FROM as_lookups

3786: IS
3787: CURSOR C_LEAD_SOURCE_CODE_Exists (c_lookup_type VARCHAR2,
3788: c_LEAD_SOURCE_CODE VARCHAR2) IS
3789: SELECT 'X'
3790: FROM as_lookups
3791: WHERE lookup_type = c_lookup_type
3792: and lookup_code = c_LEAD_SOURCE_CODE
3793: and enabled_flag = 'Y';
3794:

Line 3811: -- LEAD_SOURCE_CODE should exist in as_lookups

3807:
3808: IF (p_LEAD_SOURCE_CODE is NOT NULL) and
3809: (p_LEAD_SOURCE_CODE <> FND_API.G_MISS_CHAR)
3810: THEN
3811: -- LEAD_SOURCE_CODE should exist in as_lookups
3812: OPEN C_LEAD_SOURCE_CODE_Exists ('LEAD_SOURCE', p_LEAD_SOURCE_CODE);
3813: FETCH C_LEAD_SOURCE_CODE_Exists into l_val;
3814:
3815: IF C_LEAD_SOURCE_CODE_Exists%NOTFOUND THEN

Line 3973: FROM as_lookups

3969: IS
3970: CURSOR C_METHODOLOGY_CODE_Exists (c_lookup_type VARCHAR2,
3971: c_METHODOLOGY_CODE VARCHAR2) IS
3972: SELECT 'X'
3973: FROM as_lookups
3974: WHERE lookup_type = c_lookup_type
3975: and lookup_code = c_METHODOLOGY_CODE
3976: and enabled_flag = 'Y';
3977:

Line 3997: -- METHODOLOGY_CODE should exist in as_lookups

3993:
3994: IF (p_METHODOLOGY_CODE is NOT NULL) and
3995: (p_METHODOLOGY_CODE <> FND_API.G_MISS_CHAR)
3996: THEN
3997: -- METHODOLOGY_CODE should exist in as_lookups
3998: OPEN C_METHODOLOGY_CODE_Exists ('METHODOLOGY_TYPE',
3999: p_METHODOLOGY_CODE);
4000: FETCH C_METHODOLOGY_CODE_Exists into l_val;
4001:

Line 4105: FROM as_lookups

4101: IS
4102: CURSOR C_DECN_TIMEFRAME_Exists (c_lookup_type VARCHAR2,
4103: c_DECISION_TIMEFRAME_CODE VARCHAR2) IS
4104: SELECT 'X'
4105: FROM as_lookups
4106: WHERE lookup_type = c_lookup_type
4107: and lookup_code = c_DECISION_TIMEFRAME_CODE
4108: and enabled_flag = 'Y';
4109:

Line 4128: -- DECISION_TIMEFRAME_CODE should exist in as_lookups

4124:
4125: IF (p_DECISION_TIMEFRAME_CODE is NOT NULL) and
4126: (p_DECISION_TIMEFRAME_CODE <> FND_API.G_MISS_CHAR)
4127: THEN
4128: -- DECISION_TIMEFRAME_CODE should exist in as_lookups
4129: OPEN C_DECN_TIMEFRAME_Exists ('DECISION_TIMEFRAME',
4130: p_DECISION_TIMEFRAME_CODE);
4131: FETCH C_DECN_TIMEFRAME_Exists into l_val;
4132:

Line 4277: -- VEHICLE_RESPONSE_CODE should exist in as_lookups

4273:
4274: IF (p_VEHICLE_RESPONSE_CODE is NOT NULL) and
4275: (p_VEHICLE_RESPONSE_CODE <> FND_API.G_MISS_CHAR)
4276: THEN
4277: -- VEHICLE_RESPONSE_CODE should exist in as_lookups
4278: OPEN C_VEHICLE_RESPONSE_Exists ('VEHICLE_RESPONSE_CODE',
4279: p_VEHICLE_RESPONSE_CODE);
4280: FETCH C_VEHICLE_RESPONSE_Exists into l_val;
4281:

Line 4321: FROM as_lookups

4317: IS
4318: CURSOR C_BUDGET_STATUS_Exists (c_lookup_type VARCHAR2,
4319: c_Lookup_Code VARCHAR2) IS
4320: SELECT 'X'
4321: FROM as_lookups
4322: WHERE lookup_type = c_lookup_type
4323: and lookup_code = c_Lookup_Code;
4324: l_val VARCHAR2(1);
4325: l_module CONSTANT VARCHAR2(255) := 'as.plsql.ldhpv.Validate_BUDGET_STATUS_CODE';

Line 4343: -- BUDGET_STATUS_CODE should exist in as_lookups

4339:
4340: IF (p_BUDGET_STATUS_CODE is NOT NULL) and
4341: (p_BUDGET_STATUS_CODE <> FND_API.G_MISS_CHAR)
4342: THEN
4343: -- BUDGET_STATUS_CODE should exist in as_lookups
4344: OPEN C_BUDGET_STATUS_Exists ('BUDGET_STATUS', p_BUDGET_STATUS_CODE);
4345: FETCH C_BUDGET_STATUS_Exists into l_val;
4346:
4347: IF C_BUDGET_STATUS_Exists%NOTFOUND THEN

Line 4386: FROM as_lookups

4382: IS
4383: CURSOR C_PRM_LEAD_TYPE_Exists (c_lookup_type VARCHAR2,
4384: c_Lookup_Code VARCHAR2) IS
4385: SELECT 'X'
4386: FROM as_lookups
4387: WHERE lookup_type = c_lookup_type
4388: and lookup_code = c_Lookup_Code;
4389: l_val VARCHAR2(1);
4390: l_module CONSTANT VARCHAR2(255) := 'as.plsql.ldhpv.Validate_PRM_LEAD_TYPE';

Line 4407: -- PRM_LEAD_TYPE should exist in as_lookups

4403:
4404: IF (p_PRM_LEAD_TYPE is NOT NULL) and
4405: (p_PRM_LEAD_TYPE <> FND_API.G_MISS_CHAR)
4406: THEN
4407: -- PRM_LEAD_TYPE should exist in as_lookups
4408: OPEN C_PRM_LEAD_TYPE_Exists ('PRM_LEAD_TYPE', p_PRM_LEAD_TYPE);
4409: FETCH C_PRM_LEAD_TYPE_Exists into l_val;
4410:
4411: IF C_PRM_LEAD_TYPE_Exists%NOTFOUND THEN

Line 5043: FROM as_lookups

5039: IS
5040: CURSOR C_AUTO_ASGN_TYPE_Exists (c_lookup_type VARCHAR2,
5041: c_Lookup_Code VARCHAR2) IS
5042: SELECT 'X'
5043: FROM as_lookups
5044: WHERE lookup_type = c_lookup_type
5045: and lookup_code = c_Lookup_Code;
5046: l_val VARCHAR2(1);
5047: l_module CONSTANT VARCHAR2(255) := 'as.plsql.ldhpv.Validate_AUTO_ASGN_TYPE';

Line 5064: -- AUTO_ASSIGNMENT_TYPE should exist in as_lookups

5060:
5061: IF (p_AUTO_ASSIGNMENT_TYPE is NOT NULL) and
5062: (p_AUTO_ASSIGNMENT_TYPE <> FND_API.G_MISS_CHAR)
5063: THEN
5064: -- AUTO_ASSIGNMENT_TYPE should exist in as_lookups
5065: OPEN C_AUTO_ASGN_TYPE_Exists ('AUTO_ASSIGNMENT_TYPE',
5066: p_AUTO_ASSIGNMENT_TYPE);
5067: FETCH C_AUTO_ASGN_TYPE_Exists into l_val;
5068:

Line 5108: FROM as_lookups

5104: IS
5105: CURSOR C_PRM_ASGN_TYPE_Exists (c_lookup_type VARCHAR2,
5106: c_Lookup_Code VARCHAR2) IS
5107: SELECT 'X'
5108: FROM as_lookups
5109: WHERE lookup_type = c_lookup_type
5110: and lookup_code = c_Lookup_Code;
5111: l_val VARCHAR2(1);
5112: l_module CONSTANT VARCHAR2(255) := 'as.plsql.ldhpv.Validate_PRM_ASGN_TYPE';

Line 5127: -- PRM_ASSIGNMENT_TYPE should exist in as_lookups

5123:
5124: IF (p_PRM_ASSIGNMENT_TYPE is NOT NULL) and
5125: (p_PRM_ASSIGNMENT_TYPE <> FND_API.G_MISS_CHAR)
5126: THEN
5127: -- PRM_ASSIGNMENT_TYPE should exist in as_lookups
5128: OPEN C_PRM_ASGN_TYPE_Exists ('PRM_ASSIGNMENT_TYPE',
5129: p_PRM_ASSIGNMENT_TYPE);
5130: FETCH C_PRM_ASGN_TYPE_Exists into l_val;
5131:

Line 5233: FROM as_lookups

5229: IS
5230: CURSOR C_PRM_IND_CLS_CODE_Exists (c_lookup_type VARCHAR2,
5231: c_Lookup_Code VARCHAR2) IS
5232: SELECT 'X'
5233: FROM as_lookups
5234: WHERE lookup_type = c_lookup_type
5235: and lookup_code = c_Lookup_Code;
5236: l_val VARCHAR2(1);
5237: l_module CONSTANT VARCHAR2(255) := 'as.plsql.ldhpv.Validate_PRM_IND_CLS_CODE';

Line 5254: -- PRM_IND_CLASSIFICATION_CODE should exist in as_lookups

5250:
5251: IF (p_PRM_IND_CLASSIFICATION_CODE is NOT NULL) and
5252: (p_PRM_IND_CLASSIFICATION_CODE <> FND_API.G_MISS_CHAR)
5253: THEN
5254: -- PRM_IND_CLASSIFICATION_CODE should exist in as_lookups
5255: OPEN C_PRM_IND_CLS_CODE_Exists ('PRM_IND_CLASSIFICATION_TYPE',
5256: p_PRM_IND_CLASSIFICATION_CODE);
5257: FETCH C_PRM_IND_CLS_CODE_Exists into l_val;
5258: