DBA Data[Home] [Help]

APPS.QP_DELAYED_REQUESTS_PVT dependencies on QP_QUALIFIER_RULES_PUB

Line 7: g_delayed_requests QP_QUALIFIER_RULES_PUB.Request_Tbl_Type;

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
10: /* Local Procedures */
11: /* Local procedure to check if a request exists for a given entity, request

Line 8: g_requesting_entities QP_QUALIFIER_RULES_PUB.Requesting_Entity_Tbl_Type;

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
10: /* Local Procedures */
11: /* Local procedure to check if a request exists for a given entity, request
12: return the result in p_request_search_result which is set to FND_API.G_TRUE

Line 130: l_request_rec QP_QUALIFIER_RULES_PUB.request_rec_type;

126: (p_request_ind IN Number
127: ,p_delete IN Varchar2 default FND_API.G_FALSE
128: ,x_return_status OUT NOCOPY VARCHAR2)
129: IS
130: l_request_rec QP_QUALIFIER_RULES_PUB.request_rec_type;
131: l_request_type VARCHAR2(30);
132: l_return_status VARCHAR2(1);
133: l_entity_id NUMBER;
134: l_entity_code Varchar2(30);

Line 137: l_set_request QP_QUALIFIER_RULES_PUB.request_tbl_type;

133: l_entity_id NUMBER;
134: l_entity_code Varchar2(30);
135: l_req_entity_ind number;
136: l_set_index NUMBER;
137: l_set_request QP_QUALIFIER_RULES_PUB.request_tbl_type;
138: l_deleted_options_tbl QP_QUALIFIER_RULES_PUB.request_tbl_type;
139: l_updated_options_tbl QP_QUALIFIER_RULES_PUB.request_tbl_type;
140: l_d_index NUMBER;
141: l_u_index NUMBER;

Line 138: l_deleted_options_tbl QP_QUALIFIER_RULES_PUB.request_tbl_type;

134: l_entity_code Varchar2(30);
135: l_req_entity_ind number;
136: l_set_index NUMBER;
137: l_set_request QP_QUALIFIER_RULES_PUB.request_tbl_type;
138: l_deleted_options_tbl QP_QUALIFIER_RULES_PUB.request_tbl_type;
139: l_updated_options_tbl QP_QUALIFIER_RULES_PUB.request_tbl_type;
140: l_d_index NUMBER;
141: l_u_index NUMBER;
142: K NUMBER;

Line 139: l_updated_options_tbl QP_QUALIFIER_RULES_PUB.request_tbl_type;

135: l_req_entity_ind number;
136: l_set_index NUMBER;
137: l_set_request QP_QUALIFIER_RULES_PUB.request_tbl_type;
138: l_deleted_options_tbl QP_QUALIFIER_RULES_PUB.request_tbl_type;
139: l_updated_options_tbl QP_QUALIFIER_RULES_PUB.request_tbl_type;
140: l_d_index NUMBER;
141: l_u_index NUMBER;
142: K NUMBER;
143: I NUMBER := 1;

Line 965: l_request QP_QUALIFIER_RULES_PUB.REQUEST_REC_TYPE;

961: l_request_search_rslt VARCHAR2(1);
962: l_return_status VARCHAR2(1);
963: l_request_ind NUMBER;
964: l_req_entity_ind NUMBER;
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');

Line 966: l_req_entity QP_QUALIFIER_RULES_PUB.Requesting_Entity_Rec_Type;

962: l_return_status VARCHAR2(1);
963: l_request_ind NUMBER;
964: l_req_entity_ind NUMBER;
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);