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 3537: FROM as_lookups

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

Line 3560: -- CLOSE_REASON should exist in as_lookups

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

Line 3789: FROM as_lookups

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

Line 3810: -- LEAD_SOURCE_CODE should exist in as_lookups

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

Line 3972: FROM as_lookups

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

Line 3996: -- METHODOLOGY_CODE should exist in as_lookups

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

Line 4104: FROM as_lookups

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

Line 4127: -- DECISION_TIMEFRAME_CODE should exist in as_lookups

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

Line 4276: -- VEHICLE_RESPONSE_CODE should exist in as_lookups

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

Line 4320: FROM as_lookups

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

Line 4342: -- BUDGET_STATUS_CODE should exist in as_lookups

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

Line 4385: FROM as_lookups

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

Line 4406: -- PRM_LEAD_TYPE should exist in as_lookups

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

Line 5042: FROM as_lookups

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

Line 5063: -- AUTO_ASSIGNMENT_TYPE should exist in as_lookups

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

Line 5107: FROM as_lookups

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

Line 5126: -- PRM_ASSIGNMENT_TYPE should exist in as_lookups

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

Line 5232: FROM as_lookups

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

Line 5253: -- PRM_IND_CLASSIFICATION_CODE should exist in as_lookups

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