DBA Data[Home] [Help]

APPS.OE_VERSION_COMP dependencies on OE_ORDER_PUB

Line 8: x_header_rec IN OUT NOCOPY OE_Order_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_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

Line 398: x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type)

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

Line 806: p_curr_rec OE_Order_PUB.Header_Rec_Type;

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;

Line 807: p_next_rec OE_Order_PUB.Header_Rec_Type;

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);

Line 808: p_prior_rec OE_Order_PUB.Header_Rec_Type;

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;

Line 7060: x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type)

7056: (p_header_id NUMBER,
7057: p_line_id NUMBER,
7058: p_version NUMBER,
7059: p_phase_change_flag VARCHAR2,
7060: x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type)
7061: IS
7062: l_org_id NUMBER;
7063: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
7064: BEGIN

Line 7746: x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type)

7742: PROCEDURE QUERY_LINE_TRANS_ROW
7743: (p_header_id NUMBER,
7744: p_line_id NUMBER,
7745: p_version NUMBER,
7746: x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type)
7747: IS
7748: l_org_id NUMBER;
7749: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
7750: BEGIN

Line 8440: p_curr_rec OE_Order_PUB.line_rec_type;

8436: x_line_changed_attr_tbl IN OUT NOCOPY OE_VERSION_COMP.line_tbl_type,
8437: p_total_lines NUMBER,
8438: x_line_number VARCHAR2)
8439: IS
8440: p_curr_rec OE_Order_PUB.line_rec_type;
8441: p_next_rec OE_Order_PUB.line_rec_type;
8442: p_prior_rec OE_Order_PUB.line_rec_type;
8443:
8444: prior_exists VARCHAR2(1) := 'N';

Line 8441: p_next_rec OE_Order_PUB.line_rec_type;

8437: p_total_lines NUMBER,
8438: x_line_number VARCHAR2)
8439: IS
8440: p_curr_rec OE_Order_PUB.line_rec_type;
8441: p_next_rec OE_Order_PUB.line_rec_type;
8442: p_prior_rec OE_Order_PUB.line_rec_type;
8443:
8444: prior_exists VARCHAR2(1) := 'N';
8445: j NUMBER;

Line 8442: p_prior_rec OE_Order_PUB.line_rec_type;

8438: x_line_number VARCHAR2)
8439: IS
8440: p_curr_rec OE_Order_PUB.line_rec_type;
8441: p_next_rec OE_Order_PUB.line_rec_type;
8442: p_prior_rec OE_Order_PUB.line_rec_type;
8443:
8444: prior_exists VARCHAR2(1) := 'N';
8445: j NUMBER;
8446: l_line_id NUMBER;

Line 18268: x_header_scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type)

18264: (p_header_id NUMBER,
18265: p_sales_credit_id NUMBER,
18266: p_version NUMBER,
18267: p_phase_change_flag VARCHAR2,
18268: x_header_scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type)
18269: IS
18270: l_org_id NUMBER;
18271: l_phase_change_flag VARCHAR2(1);
18272: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 18386: x_header_scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type)

18382: PROCEDURE QUERY_HEADER_SC_TRANS_ROW
18383: (p_header_id NUMBER,
18384: p_sales_credit_id NUMBER,
18385: p_version NUMBER,
18386: x_header_scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type)
18387: IS
18388: l_org_id NUMBER;
18389: l_phase_change_flag VARCHAR2(1);
18390: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 18507: p_curr_rec OE_Order_PUB.Header_scredit_Rec_Type;

18503: g_next_phase_change_flag VARCHAR2,
18504: x_header_sc_changed_attr_tbl IN OUT NOCOPY OE_VERSION_COMP.header_sc_tbl_type,
18505: p_total_lines NUMBER)
18506: IS
18507: p_curr_rec OE_Order_PUB.Header_scredit_Rec_Type;
18508: p_next_rec OE_Order_PUB.Header_scredit_Rec_Type;
18509: p_prior_rec OE_Order_PUB.Header_scredit_Rec_Type;
18510:
18511:

Line 18508: p_next_rec OE_Order_PUB.Header_scredit_Rec_Type;

18504: x_header_sc_changed_attr_tbl IN OUT NOCOPY OE_VERSION_COMP.header_sc_tbl_type,
18505: p_total_lines NUMBER)
18506: IS
18507: p_curr_rec OE_Order_PUB.Header_scredit_Rec_Type;
18508: p_next_rec OE_Order_PUB.Header_scredit_Rec_Type;
18509: p_prior_rec OE_Order_PUB.Header_scredit_Rec_Type;
18510:
18511:
18512: v_totcol NUMBER:=10;

Line 18509: p_prior_rec OE_Order_PUB.Header_scredit_Rec_Type;

18505: p_total_lines NUMBER)
18506: IS
18507: p_curr_rec OE_Order_PUB.Header_scredit_Rec_Type;
18508: p_next_rec OE_Order_PUB.Header_scredit_Rec_Type;
18509: p_prior_rec OE_Order_PUB.Header_scredit_Rec_Type;
18510:
18511:
18512: v_totcol NUMBER:=10;
18513: v_header_col VARCHAR2(50);

Line 19692: x_line_scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type)

19688: (p_header_id NUMBER,
19689: p_sales_credit_id NUMBER,
19690: p_version NUMBER,
19691: p_phase_change_flag VARCHAR2,
19692: x_line_scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type)
19693: IS
19694: l_org_id NUMBER;
19695: l_phase_change_flag VARCHAR2(1);
19696: BEGIN

Line 19802: x_line_scredit_rec IN OUT NOCOPY OE_Order_PUB.line_Scredit_Rec_Type)

19798: PROCEDURE QUERY_line_SC_TRANS_ROW
19799: (p_header_id NUMBER,
19800: p_sales_credit_id NUMBER,
19801: p_version NUMBER,
19802: x_line_scredit_rec IN OUT NOCOPY OE_Order_PUB.line_Scredit_Rec_Type)
19803: IS
19804: l_org_id NUMBER;
19805: l_phase_change_flag VARCHAR2(1);
19806: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 19925: p_curr_rec OE_Order_PUB.line_scredit_Rec_Type;

19921: x_line_sc_changed_attr_tbl IN OUT NOCOPY OE_VERSION_COMP.line_sc_tbl_type,
19922: p_total_lines NUMBER,
19923: x_line_number VARCHAR2)
19924: IS
19925: p_curr_rec OE_Order_PUB.line_scredit_Rec_Type;
19926: p_next_rec OE_Order_PUB.line_scredit_Rec_Type;
19927: p_prior_rec OE_Order_PUB.line_scredit_Rec_Type;
19928:
19929:

Line 19926: p_next_rec OE_Order_PUB.line_scredit_Rec_Type;

19922: p_total_lines NUMBER,
19923: x_line_number VARCHAR2)
19924: IS
19925: p_curr_rec OE_Order_PUB.line_scredit_Rec_Type;
19926: p_next_rec OE_Order_PUB.line_scredit_Rec_Type;
19927: p_prior_rec OE_Order_PUB.line_scredit_Rec_Type;
19928:
19929:
19930: v_totcol NUMBER:=10;

Line 19927: p_prior_rec OE_Order_PUB.line_scredit_Rec_Type;

19923: x_line_number VARCHAR2)
19924: IS
19925: p_curr_rec OE_Order_PUB.line_scredit_Rec_Type;
19926: p_next_rec OE_Order_PUB.line_scredit_Rec_Type;
19927: p_prior_rec OE_Order_PUB.line_scredit_Rec_Type;
19928:
19929:
19930: v_totcol NUMBER:=10;
19931: v_line_col VARCHAR2(50);