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.QP_DELAYED_REQUESTS_PVT dependencies on QP_DELAYED_REQUESTS_PVT

Line 1: PACKAGE BODY QP_Delayed_Requests_PVT AS

1: PACKAGE BODY QP_Delayed_Requests_PVT AS
2: /* $Header: QPXVREQB.pls 120.6.12020000.2 2012/09/18 11:56:19 kdurgasi ship $ */
3: -- Global constant holding the package name
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'QP_Delayed_Requests_PVT';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'QP_Delayed_Requests_PVT';

1: PACKAGE BODY QP_Delayed_Requests_PVT AS
2: /* $Header: QPXVREQB.pls 120.6.12020000.2 2012/09/18 11:56:19 kdurgasi ship $ */
3: -- Global constant holding the package name
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'QP_Delayed_Requests_PVT';
6:
7: g_delayed_requests QP_QUALIFIER_RULES_PUB.Request_Tbl_Type;
8: g_requesting_entities QP_QUALIFIER_RULES_PUB.Requesting_Entity_Tbl_Type;
9: G_MAX_REQUESTS NUMBER := 1000; --2502849

Line 49: oe_debug_pub.add('Entering Procedure Check_for_Request in Package QP_Delayed_Requests_Pvt');

45: BEGIN
46: x_return_status := FND_API.G_RET_STS_SUCCESS;
47: x_result := FND_API.G_FALSE;
48:
49: oe_debug_pub.add('Entering Procedure Check_for_Request in Package QP_Delayed_Requests_Pvt');
50:
51: -- 2502849 l_ind to l_max_ind is the range of index positions that can
52: -- hold requests for this entity id - for e.g. if entity_id is
53: -- 2341 and G_MAX_REQUESTS is 1000 then the range would be:

Line 969: oe_debug_pub.add('Entering Procedure Log_Request in Package QP_Delayed_Requests_Pvt');

965: l_request QP_QUALIFIER_RULES_PUB.REQUEST_REC_TYPE;
966: l_req_entity QP_QUALIFIER_RULES_PUB.Requesting_Entity_Rec_Type;
967: BEGIN
968:
969: oe_debug_pub.add('Entering Procedure Log_Request in Package QP_Delayed_Requests_Pvt');
970: oe_debug_pub.add('log_request_type'||p_request_type);
971:
972: -- Initialize the request_record
973: l_request.request_type := p_request_type;

Line 1130: oe_debug_pub.add('Entering Procedure Delete_Request in Package QP_Delayed_Requests_Pvt');

1126: l_request_ind number;
1127: l_req_entity_ind number;
1128: BEGIN
1129:
1130: oe_debug_pub.add('Entering Procedure Delete_Request in Package QP_Delayed_Requests_Pvt');
1131:
1132: x_return_status := FND_API.G_RET_STS_SUCCESS;
1133: IF p_entity_id IS NOT NULL THEN --2650093
1134: Check_for_Request( p_entity_code => p_entity_code

Line 1201: oe_debug_pub.add('Entering Procedure Clear_Request in Package QP_Delayed_Requests_Pvt');

1197: Procedure Clear_Request( x_return_status OUT NOCOPY VARCHAR2)
1198: IS
1199: BEGIN
1200:
1201: oe_debug_pub.add('Entering Procedure Clear_Request in Package QP_Delayed_Requests_Pvt');
1202:
1203: x_return_status := FND_API.G_RET_STS_SUCCESS;
1204:
1205: G_Delayed_Requests.DELETE;

Line 1240: oe_debug_pub.add('Entering Procedure Process_Request in Package QP_Delayed_Requests_Pvt');

1236: l_return_status Varchar2(30);
1237: Begin
1238: x_return_status := FND_API.G_RET_STS_SUCCESS;
1239:
1240: oe_debug_pub.add('Entering Procedure Process_Request in Package QP_Delayed_Requests_Pvt');
1241: IF p_entity_id IS NOT NULL THEN --2650093
1242: Check_for_Request( p_entity_code => p_entity_code
1243: ,p_entity_id => p_entity_id
1244: ,p_request_type => p_request_type

Line 1308: oe_debug_pub.add('Entering Procedure Process_Request_for_Entity in Package QP_Delayed_Requests_Pvt');

1304: l_ind Number;
1305: Begin
1306: x_return_status := FND_API.G_RET_STS_SUCCESS;
1307:
1308: oe_debug_pub.add('Entering Procedure Process_Request_for_Entity in Package QP_Delayed_Requests_Pvt');
1309: --dbms_output.put_line('Entering Procedure Process_Request_for_Entity in Package QP_Delayed_Requests_Pvt');
1310: --dbms_output.put_line('entity id is ' ||p_entity_code);
1311:
1312: l_ind := G_Delayed_Requests.first;

Line 1309: --dbms_output.put_line('Entering Procedure Process_Request_for_Entity in Package QP_Delayed_Requests_Pvt');

1305: Begin
1306: x_return_status := FND_API.G_RET_STS_SUCCESS;
1307:
1308: oe_debug_pub.add('Entering Procedure Process_Request_for_Entity in Package QP_Delayed_Requests_Pvt');
1309: --dbms_output.put_line('Entering Procedure Process_Request_for_Entity in Package QP_Delayed_Requests_Pvt');
1310: --dbms_output.put_line('entity id is ' ||p_entity_code);
1311:
1312: l_ind := G_Delayed_Requests.first;
1313:

Line 1382: oe_debug_pub.add('Entering Procedure Process_Request_for_ReqType in Package QP_Delayed_Requests_Pvt');

1378: l_ind Number;
1379: Begin
1380: x_return_status := FND_API.G_RET_STS_SUCCESS;
1381:
1382: oe_debug_pub.add('Entering Procedure Process_Request_for_ReqType in Package QP_Delayed_Requests_Pvt');
1383:
1384: l_ind := G_Delayed_Requests.first;
1385:
1386: WHILE l_ind IS NOT NULL LOOP

Line 1434: oe_debug_pub.add('Entering Procedure Process_Delayed_Requests in Package QP_Delayed_Requests_Pvt');

1430: ) IS
1431: l_return_status Varchar2(30);
1432: Begin
1433:
1434: oe_debug_pub.add('Entering Procedure Process_Delayed_Requests in Package QP_Delayed_Requests_Pvt');
1435:
1436: -- Process requests as per the dependency
1437: -- This procedure processes all requests.
1438: -- For each request type defined in QP_GLOBALS

Line 1956: END QP_Delayed_Requests_Pvt;

1952:
1953:
1954:
1955:
1956: END QP_Delayed_Requests_Pvt;