2: /* $Header: QPXBUTLS.pls 120.1.12010000.1 2008/07/28 11:50:44 appldev ship $ */
3:
4: PROCEDURE LOAD_INS_HEADER
5: ( P_REQUEST_ID IN NUMBER
6: ,X_HEADER_REC OUT NOCOPY QP_BULK_LOADER_PUB.HEADER_REC_TYPE
7: );
8:
9: PROCEDURE LOAD_UDT_HEADER
10: ( P_REQUEST_ID IN NUMBER
7: );
8:
9: PROCEDURE LOAD_UDT_HEADER
10: ( P_REQUEST_ID IN NUMBER
11: ,X_HEADER_REC OUT NOCOPY QP_BULK_LOADER_PUB.HEADER_REC_TYPE
12: );
13:
14: PROCEDURE INSERT_HEADER(p_header_rec IN OUT NOCOPY QP_BULK_LOADER_PUB.HEADER_REC_TYPE);
15:
10: ( P_REQUEST_ID IN NUMBER
11: ,X_HEADER_REC OUT NOCOPY QP_BULK_LOADER_PUB.HEADER_REC_TYPE
12: );
13:
14: PROCEDURE INSERT_HEADER(p_header_rec IN OUT NOCOPY QP_BULK_LOADER_PUB.HEADER_REC_TYPE);
15:
16: PROCEDURE INSERT_LINE(p_line_rec IN OUT NOCOPY QP_BULK_LOADER_PUB.LINE_REC_TYPE);
17:
18: PROCEDURE INSERT_QUALIFIER
12: );
13:
14: PROCEDURE INSERT_HEADER(p_header_rec IN OUT NOCOPY QP_BULK_LOADER_PUB.HEADER_REC_TYPE);
15:
16: PROCEDURE INSERT_LINE(p_line_rec IN OUT NOCOPY QP_BULK_LOADER_PUB.LINE_REC_TYPE);
17:
18: PROCEDURE INSERT_QUALIFIER
19: (P_QUALIFIER_REC IN OUT NOCOPY QP_BULK_LOADER_PUB.Qualifier_Rec_Type);
20:
15:
16: PROCEDURE INSERT_LINE(p_line_rec IN OUT NOCOPY QP_BULK_LOADER_PUB.LINE_REC_TYPE);
17:
18: PROCEDURE INSERT_QUALIFIER
19: (P_QUALIFIER_REC IN OUT NOCOPY QP_BULK_LOADER_PUB.Qualifier_Rec_Type);
20:
21: PROCEDURE INSERT_PRICING_ATTR
22: (P_PRICING_ATTR_REC IN OUT NOCOPY QP_BULK_LOADER_PUB.Pricing_Attr_Rec_Type);
23:
18: PROCEDURE INSERT_QUALIFIER
19: (P_QUALIFIER_REC IN OUT NOCOPY QP_BULK_LOADER_PUB.Qualifier_Rec_Type);
20:
21: PROCEDURE INSERT_PRICING_ATTR
22: (P_PRICING_ATTR_REC IN OUT NOCOPY QP_BULK_LOADER_PUB.Pricing_Attr_Rec_Type);
23:
24: PROCEDURE UPDATE_HEADER(p_header_rec IN OUT NOCOPY QP_BULK_LOADER_PUB.HEADER_REC_TYPE);
25:
26: PROCEDURE UPDATE_LINE(p_line_rec IN OUT NOCOPY QP_BULK_LOADER_PUB.LINE_REC_TYPE);
20:
21: PROCEDURE INSERT_PRICING_ATTR
22: (P_PRICING_ATTR_REC IN OUT NOCOPY QP_BULK_LOADER_PUB.Pricing_Attr_Rec_Type);
23:
24: PROCEDURE UPDATE_HEADER(p_header_rec IN OUT NOCOPY QP_BULK_LOADER_PUB.HEADER_REC_TYPE);
25:
26: PROCEDURE UPDATE_LINE(p_line_rec IN OUT NOCOPY QP_BULK_LOADER_PUB.LINE_REC_TYPE);
27:
28: PROCEDURE UPDATE_LINE_TO_OLD(p_line_rec IN OUT NOCOPY QP_BULK_LOADER_PUB.LINE_REC_TYPE); -- 6028305
22: (P_PRICING_ATTR_REC IN OUT NOCOPY QP_BULK_LOADER_PUB.Pricing_Attr_Rec_Type);
23:
24: PROCEDURE UPDATE_HEADER(p_header_rec IN OUT NOCOPY QP_BULK_LOADER_PUB.HEADER_REC_TYPE);
25:
26: PROCEDURE UPDATE_LINE(p_line_rec IN OUT NOCOPY QP_BULK_LOADER_PUB.LINE_REC_TYPE);
27:
28: PROCEDURE UPDATE_LINE_TO_OLD(p_line_rec IN OUT NOCOPY QP_BULK_LOADER_PUB.LINE_REC_TYPE); -- 6028305
29:
30: PROCEDURE UPDATE_QUALIFIER
24: PROCEDURE UPDATE_HEADER(p_header_rec IN OUT NOCOPY QP_BULK_LOADER_PUB.HEADER_REC_TYPE);
25:
26: PROCEDURE UPDATE_LINE(p_line_rec IN OUT NOCOPY QP_BULK_LOADER_PUB.LINE_REC_TYPE);
27:
28: PROCEDURE UPDATE_LINE_TO_OLD(p_line_rec IN OUT NOCOPY QP_BULK_LOADER_PUB.LINE_REC_TYPE); -- 6028305
29:
30: PROCEDURE UPDATE_QUALIFIER
31: (P_QUALIFIER_REC IN OUT NOCOPY QP_BULK_LOADER_PUB.Qualifier_Rec_Type);
32:
27:
28: PROCEDURE UPDATE_LINE_TO_OLD(p_line_rec IN OUT NOCOPY QP_BULK_LOADER_PUB.LINE_REC_TYPE); -- 6028305
29:
30: PROCEDURE UPDATE_QUALIFIER
31: (P_QUALIFIER_REC IN OUT NOCOPY QP_BULK_LOADER_PUB.Qualifier_Rec_Type);
32:
33: PROCEDURE UPDATE_PRICING_ATTR
34: (P_PRICING_ATTR_REC IN OUT NOCOPY QP_BULK_LOADER_PUB.Pricing_Attr_Rec_Type);
35:
30: PROCEDURE UPDATE_QUALIFIER
31: (P_QUALIFIER_REC IN OUT NOCOPY QP_BULK_LOADER_PUB.Qualifier_Rec_Type);
32:
33: PROCEDURE UPDATE_PRICING_ATTR
34: (P_PRICING_ATTR_REC IN OUT NOCOPY QP_BULK_LOADER_PUB.Pricing_Attr_Rec_Type);
35:
36: PROCEDURE Delete_Header(p_request_id NUMBER);
37:
38: PROCEDURE Delete_Line(p_request_id NUMBER);