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_Order_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
394:
395: PROCEDURE QUERY_HEADER_TRANS_ROW
396: (p_header_id NUMBER,
397: p_version NUMBER,
398: x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type)
399: IS
400: l_org_id NUMBER;
401: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
402: BEGIN
802: g_curr_phase_change_flag VARCHAR2,
803: g_next_phase_change_flag VARCHAR2,
804: x_header_changed_attr_tbl IN OUT NOCOPY OE_VERSION_COMP.header_tbl_type)
805: IS
806: p_curr_rec OE_Order_PUB.Header_Rec_Type;
807: p_next_rec OE_Order_PUB.Header_Rec_Type;
808: p_prior_rec OE_Order_PUB.Header_Rec_Type;
809:
810: v_totcol NUMBER := 10;
803: g_next_phase_change_flag VARCHAR2,
804: x_header_changed_attr_tbl IN OUT NOCOPY OE_VERSION_COMP.header_tbl_type)
805: IS
806: p_curr_rec OE_Order_PUB.Header_Rec_Type;
807: p_next_rec OE_Order_PUB.Header_Rec_Type;
808: p_prior_rec OE_Order_PUB.Header_Rec_Type;
809:
810: v_totcol NUMBER := 10;
811: v_header_col VARCHAR2(50);
804: x_header_changed_attr_tbl IN OUT NOCOPY OE_VERSION_COMP.header_tbl_type)
805: IS
806: p_curr_rec OE_Order_PUB.Header_Rec_Type;
807: p_next_rec OE_Order_PUB.Header_Rec_Type;
808: p_prior_rec OE_Order_PUB.Header_Rec_Type;
809:
810: v_totcol NUMBER := 10;
811: v_header_col VARCHAR2(50);
812: ind NUMBER;
7181: (p_header_id NUMBER,
7182: p_line_id NUMBER,
7183: p_version NUMBER,
7184: p_phase_change_flag VARCHAR2,
7185: x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type)
7186: IS
7187: l_org_id NUMBER;
7188: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
7189: BEGIN
7883: PROCEDURE QUERY_LINE_TRANS_ROW
7884: (p_header_id NUMBER,
7885: p_line_id NUMBER,
7886: p_version NUMBER,
7887: x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type)
7888: IS
7889: l_org_id NUMBER;
7890: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
7891: BEGIN
8593: x_line_changed_attr_tbl IN OUT NOCOPY OE_VERSION_COMP.line_tbl_type,
8594: p_total_lines NUMBER,
8595: x_line_number VARCHAR2)
8596: IS
8597: p_curr_rec OE_Order_PUB.line_rec_type;
8598: p_next_rec OE_Order_PUB.line_rec_type;
8599: p_prior_rec OE_Order_PUB.line_rec_type;
8600:
8601: prior_exists VARCHAR2(1) := 'N';
8594: p_total_lines NUMBER,
8595: x_line_number VARCHAR2)
8596: IS
8597: p_curr_rec OE_Order_PUB.line_rec_type;
8598: p_next_rec OE_Order_PUB.line_rec_type;
8599: p_prior_rec OE_Order_PUB.line_rec_type;
8600:
8601: prior_exists VARCHAR2(1) := 'N';
8602: j NUMBER;
8595: x_line_number VARCHAR2)
8596: IS
8597: p_curr_rec OE_Order_PUB.line_rec_type;
8598: p_next_rec OE_Order_PUB.line_rec_type;
8599: p_prior_rec OE_Order_PUB.line_rec_type;
8600:
8601: prior_exists VARCHAR2(1) := 'N';
8602: j NUMBER;
8603: l_line_id NUMBER;
18789: (p_header_id NUMBER,
18790: p_sales_credit_id NUMBER,
18791: p_version NUMBER,
18792: p_phase_change_flag VARCHAR2,
18793: x_header_scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type)
18794: IS
18795: l_org_id NUMBER;
18796: l_phase_change_flag VARCHAR2(1);
18797: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
18907: PROCEDURE QUERY_HEADER_SC_TRANS_ROW
18908: (p_header_id NUMBER,
18909: p_sales_credit_id NUMBER,
18910: p_version NUMBER,
18911: x_header_scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type)
18912: IS
18913: l_org_id NUMBER;
18914: l_phase_change_flag VARCHAR2(1);
18915: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
19028: g_next_phase_change_flag VARCHAR2,
19029: x_header_sc_changed_attr_tbl IN OUT NOCOPY OE_VERSION_COMP.header_sc_tbl_type,
19030: p_total_lines NUMBER)
19031: IS
19032: p_curr_rec OE_Order_PUB.Header_scredit_Rec_Type;
19033: p_next_rec OE_Order_PUB.Header_scredit_Rec_Type;
19034: p_prior_rec OE_Order_PUB.Header_scredit_Rec_Type;
19035:
19036:
19029: x_header_sc_changed_attr_tbl IN OUT NOCOPY OE_VERSION_COMP.header_sc_tbl_type,
19030: p_total_lines NUMBER)
19031: IS
19032: p_curr_rec OE_Order_PUB.Header_scredit_Rec_Type;
19033: p_next_rec OE_Order_PUB.Header_scredit_Rec_Type;
19034: p_prior_rec OE_Order_PUB.Header_scredit_Rec_Type;
19035:
19036:
19037: v_totcol NUMBER:=10;
19030: p_total_lines NUMBER)
19031: IS
19032: p_curr_rec OE_Order_PUB.Header_scredit_Rec_Type;
19033: p_next_rec OE_Order_PUB.Header_scredit_Rec_Type;
19034: p_prior_rec OE_Order_PUB.Header_scredit_Rec_Type;
19035:
19036:
19037: v_totcol NUMBER:=10;
19038: v_header_col VARCHAR2(50);
20217: (p_header_id NUMBER,
20218: p_sales_credit_id NUMBER,
20219: p_version NUMBER,
20220: p_phase_change_flag VARCHAR2,
20221: x_line_scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type)
20222: IS
20223: l_org_id NUMBER;
20224: l_phase_change_flag VARCHAR2(1);
20225: BEGIN
20329: PROCEDURE QUERY_line_SC_TRANS_ROW
20330: (p_header_id NUMBER,
20331: p_sales_credit_id NUMBER,
20332: p_version NUMBER,
20333: x_line_scredit_rec IN OUT NOCOPY OE_Order_PUB.line_Scredit_Rec_Type)
20334: IS
20335: l_org_id NUMBER;
20336: l_phase_change_flag VARCHAR2(1);
20337: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
20452: x_line_sc_changed_attr_tbl IN OUT NOCOPY OE_VERSION_COMP.line_sc_tbl_type,
20453: p_total_lines NUMBER,
20454: x_line_number VARCHAR2)
20455: IS
20456: p_curr_rec OE_Order_PUB.line_scredit_Rec_Type;
20457: p_next_rec OE_Order_PUB.line_scredit_Rec_Type;
20458: p_prior_rec OE_Order_PUB.line_scredit_Rec_Type;
20459:
20460:
20453: p_total_lines NUMBER,
20454: x_line_number VARCHAR2)
20455: IS
20456: p_curr_rec OE_Order_PUB.line_scredit_Rec_Type;
20457: p_next_rec OE_Order_PUB.line_scredit_Rec_Type;
20458: p_prior_rec OE_Order_PUB.line_scredit_Rec_Type;
20459:
20460:
20461: v_totcol NUMBER:=10;
20454: x_line_number VARCHAR2)
20455: IS
20456: p_curr_rec OE_Order_PUB.line_scredit_Rec_Type;
20457: p_next_rec OE_Order_PUB.line_scredit_Rec_Type;
20458: p_prior_rec OE_Order_PUB.line_scredit_Rec_Type;
20459:
20460:
20461: v_totcol NUMBER:=10;
20462: v_line_col VARCHAR2(50);