DBA Data[Home] [Help]

APPS.OE_VERSION_BLANKET_COMP dependencies on OE_BLANKET_PUB

Line 8: x_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_Rec_Type)

4: PROCEDURE QUERY_HEADER_ROW
5: (p_header_id NUMBER,
6: p_version NUMBER,
7: p_phase_change_flag VARCHAR2,
8: x_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_Rec_Type)
9: IS
10: l_org_id NUMBER;
11: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
12: BEGIN

Line 233: x_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_Rec_Type)

229:
230: PROCEDURE QUERY_HEADER_TRANS_ROW
231: (p_header_id NUMBER,
232: p_version NUMBER,
233: x_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_Rec_Type)
234: IS
235: l_org_id NUMBER;
236: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
237: BEGIN

Line 466: p_curr_rec OE_Blanket_PUB.Header_Rec_Type;

462: g_curr_phase_change_flag VARCHAR2,
463: g_next_phase_change_flag VARCHAR2,
464: x_header_changed_attr_tbl IN OUT NOCOPY OE_VERSION_BLANKET_COMP.header_tbl_type)
465: IS
466: p_curr_rec OE_Blanket_PUB.Header_Rec_Type;
467: p_next_rec OE_Blanket_PUB.Header_Rec_Type;
468: p_prior_rec OE_Blanket_PUB.Header_Rec_Type;
469:
470:

Line 467: p_next_rec OE_Blanket_PUB.Header_Rec_Type;

463: g_next_phase_change_flag VARCHAR2,
464: x_header_changed_attr_tbl IN OUT NOCOPY OE_VERSION_BLANKET_COMP.header_tbl_type)
465: IS
466: p_curr_rec OE_Blanket_PUB.Header_Rec_Type;
467: p_next_rec OE_Blanket_PUB.Header_Rec_Type;
468: p_prior_rec OE_Blanket_PUB.Header_Rec_Type;
469:
470:
471: v_totcol NUMBER:=10;

Line 468: p_prior_rec OE_Blanket_PUB.Header_Rec_Type;

464: x_header_changed_attr_tbl IN OUT NOCOPY OE_VERSION_BLANKET_COMP.header_tbl_type)
465: IS
466: p_curr_rec OE_Blanket_PUB.Header_Rec_Type;
467: p_next_rec OE_Blanket_PUB.Header_Rec_Type;
468: p_prior_rec OE_Blanket_PUB.Header_Rec_Type;
469:
470:
471: v_totcol NUMBER:=10;
472: v_header_col VARCHAR2(50);

Line 4036: x_line_rec IN OUT NOCOPY OE_Blanket_PUB.line_rec_type)

4032: (p_header_id NUMBER,
4033: p_line_id NUMBER,
4034: p_version NUMBER,
4035: p_phase_change_flag VARCHAR2,
4036: x_line_rec IN OUT NOCOPY OE_Blanket_PUB.line_rec_type)
4037: IS
4038: l_org_id NUMBER;
4039: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4040: BEGIN

Line 4246: x_line_rec IN OUT NOCOPY OE_Blanket_PUB.line_rec_type)

4242: PROCEDURE QUERY_LINE_TRANS_ROW
4243: (p_header_id NUMBER,
4244: p_line_id NUMBER,
4245: p_version NUMBER,
4246: x_line_rec IN OUT NOCOPY OE_Blanket_PUB.line_rec_type)
4247: IS
4248: l_org_id NUMBER;
4249: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4250: BEGIN

Line 4463: p_curr_rec OE_Blanket_PUB.line_rec_type;

4459: x_line_changed_attr_tbl IN OUT NOCOPY OE_VERSION_BLANKET_COMP.line_tbl_type,
4460: p_total_lines NUMBER,
4461: x_line_number NUMBER)
4462: IS
4463: p_curr_rec OE_Blanket_PUB.line_rec_type;
4464: p_next_rec OE_Blanket_PUB.line_rec_type;
4465: p_prior_rec OE_Blanket_PUB.line_rec_type;
4466:
4467:

Line 4464: p_next_rec OE_Blanket_PUB.line_rec_type;

4460: p_total_lines NUMBER,
4461: x_line_number NUMBER)
4462: IS
4463: p_curr_rec OE_Blanket_PUB.line_rec_type;
4464: p_next_rec OE_Blanket_PUB.line_rec_type;
4465: p_prior_rec OE_Blanket_PUB.line_rec_type;
4466:
4467:
4468: prior_exists VARCHAR2(1) := 'N';

Line 4465: p_prior_rec OE_Blanket_PUB.line_rec_type;

4461: x_line_number NUMBER)
4462: IS
4463: p_curr_rec OE_Blanket_PUB.line_rec_type;
4464: p_next_rec OE_Blanket_PUB.line_rec_type;
4465: p_prior_rec OE_Blanket_PUB.line_rec_type;
4466:
4467:
4468: prior_exists VARCHAR2(1) := 'N';
4469: j NUMBER;