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_PP_RESRC_REQUIRE_PVT dependencies on STANDARD

Line 1010: -- Standard IN Parameters :

1006: -- Type : Private
1007: -- Pre-reqs :
1008: -- Parameters :
1009: --
1010: -- Standard IN Parameters :
1011: -- p_api_version IN NUMBER Required
1012: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1013: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1014: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 1018: -- Standard OUT Parameters :

1014: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1015: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
1016: -- p_module_type IN VARCHAR2 Default NULL.
1017: --
1018: -- Standard OUT Parameters :
1019: -- x_return_status OUT VARCHAR2 Required
1020: -- x_msg_count OUT NUMBER Required
1021: -- x_msg_data OUT VARCHAR2 Required
1022: --

Line 1127: STANDARD_RATE_FLAG, resource_type

1123: -- Added resource_type for bug# 6512803.
1124: CURSOR c_get_std_rate_flag(p_resource_id NUMBER)
1125: IS
1126: SELECT
1127: STANDARD_RATE_FLAG, resource_type
1128: FROM
1129: BOM_RESOURCES
1130: WHERE
1131: resource_id = p_resource_id;

Line 1194: -- Standard Start of API savepoint

1190: l_resource_type bom_resources.resource_type%TYPE;
1191:
1192: BEGIN
1193: --------------------Initialize ----------------------------------
1194: -- Standard Start of API savepoint
1195: SAVEPOINT Create_Resrc_Require;
1196: -- Check if API is called in debug mode. If yes, enable debug.
1197: IF G_DEBUG='Y' THEN
1198: AHL_DEBUG_PUB.enable_debug;

Line 1211: -- Standard call to check for call compatibility.

1207: Ahl_Debug_Pub.debug( 'Enter AHL_PP_RESRC_Require_PVT. Create_Resrc_Require +PPResrc_Require_Pvt+');
1208: END IF;
1209: G_MODULE_TYPE:=P_MODULE_TYPE;
1210:
1211: -- Standard call to check for call compatibility.
1212: IF FND_API.to_boolean(p_init_msg_list)
1213: THEN
1214: FND_MSG_PUB.initialize;
1215: END IF;

Line 1533: Ahl_Debug_Pub.debug ( l_full_name || ' STANDARD RATE FLAG = ' || l_Resrc_Require_Rec.STD_RATE_FLAG_CODE);

1529: END IF;
1530: END IF;
1531: IF G_DEBUG='Y' THEN
1532: Ahl_Debug_Pub.debug ( l_full_name || ' SCHEDULED TYPE CODE = ' || l_Resrc_Require_Rec.SCHEDULED_TYPE_CODE);
1533: Ahl_Debug_Pub.debug ( l_full_name || ' STANDARD RATE FLAG = ' || l_Resrc_Require_Rec.STD_RATE_FLAG_CODE);
1534: END IF;
1535: -- To find meaning for fnd_lookups code
1536: IF (l_Resrc_Require_Rec.STD_RATE_FLAG_CODE IS NOT NULL AND
1537: l_Resrc_Require_Rec.STD_RATE_FLAG_CODE <> Fnd_Api.G_MISS_NUM) THEN

Line 1584: --Standard check to count messages

1580: END IF;
1581: IF G_DEBUG='Y' THEN
1582: Ahl_Debug_Pub.debug ( l_full_name || ' ******After calling Validate_Resrc_Require****');
1583: END IF;
1584: --Standard check to count messages
1585: l_msg_count := Fnd_Msg_Pub.count_msg;
1586:
1587: IF l_msg_count > 0 THEN
1588: x_msg_count := l_msg_count;

Line 1880: --Standard check to count messages

1876: Ahl_Debug_Pub.debug ('after wip load p_x_resrc_Require_tbl.COUNT'||p_x_resrc_Require_tbl.COUNT);
1877:
1878: END IF;
1879:
1880: --Standard check to count messages
1881: l_msg_count := Fnd_Msg_Pub.count_msg;
1882: IF l_msg_count > 0 THEN
1883: X_msg_count := l_msg_count;
1884: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 2003: --Standard check to count messages

1999: END IF;
2000:
2001: --END IF;
2002: ------------------------End of Body---------------------------------------
2003: --Standard check to count messages
2004: l_msg_count := Fnd_Msg_Pub.count_msg;
2005: IF l_msg_count > 0 THEN
2006: X_msg_count := l_msg_count;
2007: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 2011: --Standard check for commit

2007: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2008: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
2009: END IF;
2010:
2011: --Standard check for commit
2012: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
2013: COMMIT;
2014: END IF;
2015: IF G_DEBUG='Y' THEN

Line 2089: -- Standard IN Parameters :

2085: -- Type : Private
2086: -- Pre-reqs :
2087: -- Parameters :
2088: --
2089: -- Standard IN Parameters :
2090: -- p_api_version IN NUMBER Required
2091: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
2092: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
2093: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 2097: -- Standard OUT Parameters :

2093: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
2094: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
2095: -- p_module_type IN VARCHAR2 Default NULL.
2096: --
2097: -- Standard OUT Parameters :
2098: -- x_return_status OUT VARCHAR2 Required
2099: -- x_msg_count OUT NUMBER Required
2100: -- x_msg_data OUT VARCHAR2 Required
2101: --

Line 2247: -- Standard Start of API savepoint

2243: l_department_id NUMBER;
2244:
2245: BEGIN
2246: --------------------Initialize ----------------------------------
2247: -- Standard Start of API savepoint
2248: SAVEPOINT Update_Resrc_Require;
2249:
2250: -- Check if API is called in debug mode. If yes, enable debug.
2251: IF G_DEBUG='Y' THEN

Line 2260: -- Standard call to check for call compatibility.

2256: Ahl_Debug_Pub.debug( 'Enter ahl_pp_resrc_require_pvt. Update Resource Requirement +PPResrc_Require_Pvt+');
2257: END IF;
2258:
2259: G_MODULE_TYPE:=P_MODULE_TYPE;
2260: -- Standard call to check for call compatibility.
2261: IF FND_API.to_boolean(p_init_msg_list)
2262: THEN
2263: FND_MSG_PUB.initialize;
2264: END IF;

Line 2581: Ahl_Debug_Pub.debug ( l_full_name || ' STANDARD RATE FLAG = ' || l_Resrc_Require_Rec.STD_RATE_FLAG_CODE);

2577: END IF;
2578: END IF;
2579: IF G_DEBUG='Y' THEN
2580: Ahl_Debug_Pub.debug ( l_full_name || ' SCHEDULED TYPE CODE = ' || l_Resrc_Require_Rec.SCHEDULED_TYPE_CODE);
2581: Ahl_Debug_Pub.debug ( l_full_name || ' STANDARD RATE FLAG = ' || l_Resrc_Require_Rec.STD_RATE_FLAG_CODE);
2582: END IF;
2583: -- To find meaning for fnd_lookups code
2584: IF (l_Resrc_Require_Rec.STD_RATE_FLAG_CODE IS NOT NULL AND
2585: l_Resrc_Require_Rec.STD_RATE_FLAG_CODE <> Fnd_Api.G_MISS_NUM) THEN

Line 2606: --Standard check to count messages

2602: x_msg_count => x_msg_count,
2603: x_msg_data => x_msg_data
2604: );
2605:
2606: --Standard check to count messages
2607: l_msg_count := Fnd_Msg_Pub.count_msg;
2608:
2609: IF l_msg_count > 0 THEN
2610: x_msg_count := l_msg_count;

Line 2913: -- Standard check to count messages

2909: END IF;
2910: END IF;
2911: --
2912: ------------------------End of Body---------------------------------------
2913: -- Standard check to count messages
2914: l_msg_count := Fnd_Msg_Pub.count_msg;
2915:
2916: IF l_msg_count > 0 THEN
2917: X_msg_count := l_msg_count;

Line 2922: --Standard check for commit

2918: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2919: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
2920: END IF;
2921:
2922: --Standard check for commit
2923: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
2924: COMMIT;
2925: END IF;
2926:

Line 3096: -- Standard start of API savepoint

3092: AND TRUNC(NVL(end_date_active,SYSDATE));
3093:
3094: BEGIN
3095: -------------------------------- Initialize -----------------------
3096: -- Standard start of API savepoint
3097: SAVEPOINT Get_Resource_Requirement;
3098: IF G_DEBUG='Y' THEN
3099: -- Check if API is called in debug mode. If yes, enable debug.
3100: Ahl_Debug_Pub.enable_debug;

Line 3108: -- Standard call to check for call compatibility.

3104: IF G_DEBUG='Y' THEN
3105: Ahl_Debug_Pub.debug ( l_full_name || ' Start ');
3106: END IF;
3107:
3108: -- Standard call to check for call compatibility.
3109: IF Fnd_Api.to_boolean(p_init_msg_list)
3110: THEN
3111: Fnd_Msg_Pub.initialize;
3112: END IF;

Line 3167: IF (c_WIP_oper_rec.STANDARD_RATE_FLAG IS NOT NULL) THEN

3163: ------------------------------------------ Start -----------------------------------
3164: -- Debug info.
3165:
3166: -- To find meaning for fnd_lookups code
3167: IF (c_WIP_oper_rec.STANDARD_RATE_FLAG IS NOT NULL) THEN
3168: SELECT meaning
3169: INTO l_std_rate_flag
3170: FROM MFG_LOOKUPS
3171: WHERE lookup_code = c_WIP_oper_rec.STANDARD_RATE_FLAG

Line 3171: WHERE lookup_code = c_WIP_oper_rec.STANDARD_RATE_FLAG

3167: IF (c_WIP_oper_rec.STANDARD_RATE_FLAG IS NOT NULL) THEN
3168: SELECT meaning
3169: INTO l_std_rate_flag
3170: FROM MFG_LOOKUPS
3171: WHERE lookup_code = c_WIP_oper_rec.STANDARD_RATE_FLAG
3172: AND LOOKUP_TYPE = 'BOM_NO_YES';
3173: END IF;
3174:
3175: OPEN c_lookups ('CST_BASIS', c_WIP_oper_rec.basis_type);

Line 3204: l_Resrc_Require_Rec.STD_RATE_FLAG_CODE := c_WIP_oper_rec.Standard_Rate_Flag ;

3200: --l_Resrc_Require_Rec.APPLIED_NUM := c_WIP_oper_rec.APPLIED_RESOURCE_VALUE;
3201: l_Resrc_Require_Rec.OPEN_NUM := (l_Resrc_Require_Rec.TOTAL_REQUIRED - l_Resrc_Require_Rec.APPLIED_NUM);
3202:
3203: l_Resrc_Require_Rec.STD_RATE_FLAG_NAME := l_std_rate_flag;
3204: l_Resrc_Require_Rec.STD_RATE_FLAG_CODE := c_WIP_oper_rec.Standard_Rate_Flag ;
3205:
3206: l_Resrc_Require_Rec.RESOURCE_SEQ_NUMBER := c_resrc_req.RESOURCE_SEQUENCE_NUM;
3207: l_Resrc_Require_Rec.OPERATION_SEQ_NUMBER := l_oper_seq_num;
3208: -- JKJAIN US space FP for ER # 6998882

Line 3259: -- Standard call to get message count and if count is 1, get message info

3255: Ahl_Debug_Pub.debug ( l_full_name || ' Operation End = ' || p_x_resrc_Require_tbl(i).OPER_END_DATE);*/
3256:
3257: END LOOP;
3258: END IF;
3259: -- Standard call to get message count and if count is 1, get message info
3260: Fnd_Msg_Pub.Count_And_Get
3261: ( p_count => x_msg_count,
3262: p_data => x_msg_data,
3263: p_encoded => Fnd_Api.g_false);

Line 3417: -- Standard Start of API savepoint

3413:
3414:
3415: BEGIN
3416: --------------------Initialize ----------------------------------
3417: -- Standard Start of API savepoint
3418: SAVEPOINT Remove_Resource_Requirement;
3419:
3420: -- Check if API is called in debug mode. If yes, enable debug.
3421: IF G_DEBUG='Y' THEN

Line 3427: -- Standard call to check for call compatibility.

3423:
3424: -- Debug info.
3425: Ahl_Debug_Pub.debug( 'Enter ahl_pp_resrc_require_pvt Remove Resource Requirement +APRRP+');
3426: END IF;
3427: -- Standard call to check for call compatibility.
3428: IF Fnd_Api.to_boolean(p_init_msg_list)
3429: THEN
3430: Fnd_Msg_Pub.initialize;
3431: END IF;

Line 3547: Ahl_Debug_Pub.debug ( ' STANDARD_RATE_FLAG = ' || l_wip_oper_res_rec.STANDARD_RATE_FLAG);

3543: --
3544: IF G_DEBUG='Y' THEN
3545: Ahl_Debug_Pub.debug ( ' AutoCharge Code = ' || l_wip_oper_res_rec.AUTOCHARGE_TYPE);
3546: Ahl_Debug_Pub.debug ( ' COST BASIS = ' || l_wip_oper_res_rec.BASIS_TYPE);
3547: Ahl_Debug_Pub.debug ( ' STANDARD_RATE_FLAG = ' || l_wip_oper_res_rec.STANDARD_RATE_FLAG);
3548: Ahl_Debug_Pub.debug ( ' l_Resrc_Require_Rec.Resource_Id = ' || l_Resrc_Require_Rec.Resource_Id);
3549: END IF;
3550: --Assign Org,Wip entity details
3551: p_x_resrc_Require_tbl(i).ORGANIZATION_ID := l_organization_id;

Line 3555: p_x_resrc_Require_tbl(i).std_rate_flag_code := l_wip_oper_res_rec.STANDARD_RATE_FLAG;

3551: p_x_resrc_Require_tbl(i).ORGANIZATION_ID := l_organization_id;
3552: p_x_resrc_Require_tbl(i).WIP_ENTITY_ID := l_wip_entity_id;
3553: p_x_resrc_Require_tbl(i).CHARGE_TYPE_CODE := l_wip_oper_res_rec.AUTOCHARGE_TYPE;
3554: p_x_resrc_Require_tbl(i).COST_BASIS_CODE := l_wip_oper_res_rec.BASIS_TYPE;
3555: p_x_resrc_Require_tbl(i).std_rate_flag_code := l_wip_oper_res_rec.STANDARD_RATE_FLAG;
3556: p_x_resrc_Require_tbl(i).scheduled_type_code := l_wip_oper_res_rec.SCHEDULED_FLAG;
3557: --Check for Eam code
3558: OPEN c_uom_code(l_Resource_Rec.Resource_Id);
3559: FETCH c_uom_code INTO l_uom_code;

Line 3668: --Standard check to count messages

3664: END IF;--Count
3665: END IF; --Return status
3666:
3667: ---------------------------End of Body---------------------------------------
3668: --Standard check to count messages
3669: l_msg_count := Fnd_Msg_Pub.count_msg;
3670:
3671: IF l_msg_count > 0 THEN
3672: X_msg_count := l_msg_count;

Line 3677: --Standard check for commit

3673: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3674: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
3675: END IF;
3676:
3677: --Standard check for commit
3678: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
3679: COMMIT;
3680: END IF;
3681:

Line 3750: -- Standard IN Parameters :

3746: -- Function : Process ............................based on operation flag
3747: -- Pre-reqs :
3748: -- Parameters :
3749: --
3750: -- Standard IN Parameters :
3751: -- p_api_version IN NUMBER Required
3752: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
3753: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
3754: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 3758: -- Standard OUT Parameters :

3754: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
3755: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
3756: -- p_module_type IN VARCHAR2 Default NULL.
3757: --
3758: -- Standard OUT Parameters :
3759: -- x_return_status OUT VARCHAR2 Required
3760: -- x_msg_count OUT NUMBER Required
3761: -- x_msg_data OUT VARCHAR2 Required
3762: --

Line 3809: -- Standard Start of API savepoint

3805: AWO.workorder_id = c_workorder_id;
3806:
3807: BEGIN
3808: --------------------Initialize ----------------------------------
3809: -- Standard Start of API savepoint
3810: SAVEPOINT Process_Resrc_Require;
3811: -- Check if API is called in debug mode. If yes, enable debug.
3812: IF G_DEBUG='Y' THEN
3813: AHL_DEBUG_PUB.enable_debug;

Line 3817: -- Standard call to check for call compatibility.

3813: AHL_DEBUG_PUB.enable_debug;
3814: -- Debug info.
3815: Ahl_Debug_Pub.debug( 'Enter AHL_PP_RESRC_Require.process_resrc_Require +PPResrc_Require_Pvt+');
3816: END IF;
3817: -- Standard call to check for call compatibility.
3818: IF FND_API.to_boolean(p_init_msg_list)
3819: THEN
3820: FND_MSG_PUB.initialize;
3821: END IF;

Line 3900: --Standard check to count messages

3896: x_msg_data => l_msg_data
3897: );
3898: END IF;
3899: ------------------------End of Body---------------------------------------
3900: --Standard check to count messages
3901: l_msg_count := Fnd_Msg_Pub.count_msg;
3902:
3903: -- Balaji added following piece of code for bug # 5099536
3904: -- Update_Job API is called to recalculate Master workorder actual dates

Line 3957: --Standard check for commit

3953: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3954: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
3955: END IF;
3956:
3957: --Standard check for commit
3958: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
3959: COMMIT;
3960: END IF;
3961: IF G_DEBUG='Y' THEN