DBA Data[Home] [Help]

APPS.QP_PRL_LOADER_PUB dependencies on QP_PRL_LOADER_PUB

Line 1: PACKAGE BODY QP_PRL_LOADER_PUB AS

1: PACKAGE BODY QP_PRL_LOADER_PUB AS
2: /* $Header: QPXPLDRB.pls 120.1 2005/06/13 00:54:55 appldev $ */
3:
4:
5: PROCEDURE Load_Price_List

Line 118: QP_PRL_LOADER_PUB.G_PROCESS_LST_REQ_TYPE := p_req_type_code; -- shulin, just in case this procedure is called independently

114:
115: BEGIN
116:
117: --dbms_output.put_line('Transferring data into pl/sql tables used as input to the PriceList BOI');
118: QP_PRL_LOADER_PUB.G_PROCESS_LST_REQ_TYPE := p_req_type_code; -- shulin, just in case this procedure is called independently
119: x_status := 1;
120:
121: SELECT process_type
122: INTO l_process_type

Line 526: QP_PRL_LOADER_PUB.G_PROCESS_LST_REQ_TYPE := p_req_type_code; -- shulin

522:
523: -- INSERT INTO FTE_JOB_ERRORS (JOB_ID,LINE_NUMBER,ERROR_MESSAGE)
524: -- VALUES (p_process_id,1,'Load Price List Called with action: ' || p_action_code);
525:
526: QP_PRL_LOADER_PUB.G_PROCESS_LST_REQ_TYPE := p_req_type_code; -- shulin
527:
528: IF p_action_code = 'C' THEN
529: Load_Price_List(p_process_id, p_req_type_code, G_temp_status, G_temp_errors);
530: END IF;

Line 534: END QP_PRL_LOADER_PUB;

530: END IF;
531:
532: END LOAD_PRICE_LIST;
533:
534: END QP_PRL_LOADER_PUB;