DBA Data[Home] [Help]

APPS.OE_CHG_ORDER_PVT dependencies on OE_ORDER_PUB

Line 352: ,p_line_rec In OE_ORDER_PUB.LINE_REC_TYPE

348:
349:
350: Procedure RecordLineHist
351: (p_line_id In Number
352: ,p_line_rec In OE_ORDER_PUB.LINE_REC_TYPE
353: := OE_Order_PUB.G_MISS_LINE_REC
354: ,p_hist_type_code In Varchar2
355: ,p_reason_code In varchar2
356: ,p_comments IN Varchar2

Line 353: := OE_Order_PUB.G_MISS_LINE_REC

349:
350: Procedure RecordLineHist
351: (p_line_id In Number
352: ,p_line_rec In OE_ORDER_PUB.LINE_REC_TYPE
353: := OE_Order_PUB.G_MISS_LINE_REC
354: ,p_hist_type_code In Varchar2
355: ,p_reason_code In varchar2
356: ,p_comments IN Varchar2
357: ,p_audit_flag IN Varchar2 := null

Line 366: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE := OE_Order_PUB.G_MISS_LINE_REC;

362: ,p_wf_activity_code IN Varchar2 := null
363: ,p_wf_result_code IN Varchar2 := null
364: ,x_return_status Out NOCOPY /* file.sql.39 change */ Varchar2
365: ) IS
366: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE := OE_Order_PUB.G_MISS_LINE_REC;
367: l_err_text Varchar2(80);
368: l_line_id number := p_line_id;
369: l_index_id number;
370: l_result VARCHAR2(30);

Line 1160: ,p_header_rec In OE_ORDER_PUB.HEADER_REC_TYPE := OE_Order_PUB.G_MISS_HEADER_REC

1156: END RecordLineHist;
1157:
1158: Procedure RecordHeaderHist
1159: (p_header_id In Number
1160: ,p_header_rec In OE_ORDER_PUB.HEADER_REC_TYPE := OE_Order_PUB.G_MISS_HEADER_REC
1161: ,p_hist_type_code In Varchar2
1162: ,p_reason_code In varchar2
1163: ,p_comments IN Varchar2
1164: ,p_audit_flag IN Varchar2 := null

Line 1174: l_header_rec OE_ORDER_PUB.HEADER_REC_TYPE := OE_Order_PUB.G_MISS_HEADER_REC;

1170: ,p_wf_result_code IN Varchar2 := null
1171: ,p_changed_attribute IN varchar2 := null
1172: ,x_return_status Out NOCOPY /* file.sql.39 change */ Varchar2
1173: ) IS
1174: l_header_rec OE_ORDER_PUB.HEADER_REC_TYPE := OE_Order_PUB.G_MISS_HEADER_REC;
1175: l_credit_card_number varchar2(10);
1176: l_credit_card_code varchar2(10);
1177: l_instrument_id number;
1178: l_credit_card_holder_name varchar2(10);

Line 1647: ,p_header_scredit_rec In OE_ORDER_PUB.HEADER_SCREDIT_REC_TYPE

1643: END RecordHeaderHist;
1644:
1645: Procedure RecordHSCreditHist
1646: (p_header_scredit_id In Number
1647: ,p_header_scredit_rec In OE_ORDER_PUB.HEADER_SCREDIT_REC_TYPE
1648: := OE_Order_PUB.G_MISS_HEADER_SCREDIT_REC
1649: ,p_hist_type_code In Varchar2
1650: ,p_reason_code In varchar2
1651: ,p_comments IN Varchar2

Line 1648: := OE_Order_PUB.G_MISS_HEADER_SCREDIT_REC

1644:
1645: Procedure RecordHSCreditHist
1646: (p_header_scredit_id In Number
1647: ,p_header_scredit_rec In OE_ORDER_PUB.HEADER_SCREDIT_REC_TYPE
1648: := OE_Order_PUB.G_MISS_HEADER_SCREDIT_REC
1649: ,p_hist_type_code In Varchar2
1650: ,p_reason_code In varchar2
1651: ,p_comments IN Varchar2
1652: ,p_audit_flag IN Varchar2 := null

Line 1661: l_header_scredit_rec OE_ORDER_PUB.HEADER_SCREDIT_REC_TYPE := OE_Order_PUB.G_MISS_HEADER_SCREDIT_REC;

1657: ,p_wf_activity_code IN Varchar2 := null
1658: ,p_wf_result_code IN Varchar2 := null
1659: ,x_return_status Out NOCOPY /* file.sql.39 change */ Varchar2
1660: ) IS
1661: l_header_scredit_rec OE_ORDER_PUB.HEADER_SCREDIT_REC_TYPE := OE_Order_PUB.G_MISS_HEADER_SCREDIT_REC;
1662:
1663: --
1664: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1665: --

Line 1798: ,p_line_scredit_rec In OE_ORDER_PUB.LINE_SCREDIT_REC_TYPE

1794: END RecordHSCreditHist;
1795:
1796: Procedure RecordLSCreditHist
1797: (p_line_scredit_id In Number
1798: ,p_line_scredit_rec In OE_ORDER_PUB.LINE_SCREDIT_REC_TYPE
1799: := OE_Order_PUB.G_MISS_LINE_SCREDIT_REC
1800: ,p_hist_type_code In Varchar2
1801: ,p_reason_code In varchar2
1802: ,p_comments IN Varchar2

Line 1799: := OE_Order_PUB.G_MISS_LINE_SCREDIT_REC

1795:
1796: Procedure RecordLSCreditHist
1797: (p_line_scredit_id In Number
1798: ,p_line_scredit_rec In OE_ORDER_PUB.LINE_SCREDIT_REC_TYPE
1799: := OE_Order_PUB.G_MISS_LINE_SCREDIT_REC
1800: ,p_hist_type_code In Varchar2
1801: ,p_reason_code In varchar2
1802: ,p_comments IN Varchar2
1803: ,p_audit_flag IN Varchar2 := null

Line 1812: l_line_scredit_rec OE_ORDER_PUB.LINE_SCREDIT_REC_TYPE := OE_Order_PUB.G_MISS_LINE_SCREDIT_REC;

1808: ,p_wf_activity_code IN Varchar2 := null
1809: ,p_wf_result_code IN Varchar2 := null
1810: ,x_return_status Out NOCOPY /* file.sql.39 change */ Varchar2
1811: ) IS
1812: l_line_scredit_rec OE_ORDER_PUB.LINE_SCREDIT_REC_TYPE := OE_Order_PUB.G_MISS_LINE_SCREDIT_REC;
1813: --
1814: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1815: --
1816: BEGIN

Line 1949: ,p_header_adj_rec In OE_ORDER_PUB.HEADER_ADJ_REC_TYPE

1945: END RecordLSCreditHist;
1946:
1947: Procedure RecordHPAdjHist
1948: (p_header_adj_id In Number
1949: ,p_header_adj_rec In OE_ORDER_PUB.HEADER_ADJ_REC_TYPE
1950: := OE_Order_PUB.G_MISS_HEADER_ADJ_REC
1951: ,p_hist_type_code In Varchar2
1952: ,p_reason_code In varchar2
1953: ,p_comments IN Varchar2

Line 1950: := OE_Order_PUB.G_MISS_HEADER_ADJ_REC

1946:
1947: Procedure RecordHPAdjHist
1948: (p_header_adj_id In Number
1949: ,p_header_adj_rec In OE_ORDER_PUB.HEADER_ADJ_REC_TYPE
1950: := OE_Order_PUB.G_MISS_HEADER_ADJ_REC
1951: ,p_hist_type_code In Varchar2
1952: ,p_reason_code In varchar2
1953: ,p_comments IN Varchar2
1954: ,p_audit_flag IN Varchar2 := null

Line 1963: l_header_adj_rec OE_ORDER_PUB.HEADER_ADJ_REC_TYPE := OE_Order_PUB.G_MISS_HEADER_ADJ_REC;

1959: ,p_wf_activity_code IN Varchar2 := null
1960: ,p_wf_result_code IN Varchar2 := null
1961: ,x_return_status Out NOCOPY /* file.sql.39 change */ Varchar2
1962: ) IS
1963: l_header_adj_rec OE_ORDER_PUB.HEADER_ADJ_REC_TYPE := OE_Order_PUB.G_MISS_HEADER_ADJ_REC;
1964: --
1965: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1966: --
1967: BEGIN

Line 2230: ,p_line_adj_rec In OE_ORDER_PUB.LINE_ADJ_REC_TYPE

2226: END RecordHPAdjHist;
2227:
2228: Procedure RecordLPAdjHist
2229: (p_line_adj_id In Number
2230: ,p_line_adj_rec In OE_ORDER_PUB.LINE_ADJ_REC_TYPE
2231: := OE_Order_PUB.G_MISS_LINE_ADJ_REC
2232: ,p_hist_type_code In Varchar2
2233: ,p_reason_code In varchar2
2234: ,p_comments IN Varchar2

Line 2231: := OE_Order_PUB.G_MISS_LINE_ADJ_REC

2227:
2228: Procedure RecordLPAdjHist
2229: (p_line_adj_id In Number
2230: ,p_line_adj_rec In OE_ORDER_PUB.LINE_ADJ_REC_TYPE
2231: := OE_Order_PUB.G_MISS_LINE_ADJ_REC
2232: ,p_hist_type_code In Varchar2
2233: ,p_reason_code In varchar2
2234: ,p_comments IN Varchar2
2235: ,p_audit_flag IN Varchar2 := null

Line 2244: l_line_adj_rec OE_ORDER_PUB.LINE_ADJ_REC_TYPE := OE_Order_PUB.G_MISS_LINE_ADJ_REC;

2240: ,p_wf_activity_code IN Varchar2 := null
2241: ,p_wf_result_code IN Varchar2 := null
2242: ,x_return_status Out NOCOPY /* file.sql.39 change */ Varchar2
2243: ) IS
2244: l_line_adj_rec OE_ORDER_PUB.LINE_ADJ_REC_TYPE := OE_Order_PUB.G_MISS_LINE_ADJ_REC;
2245: --
2246: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2247: --
2248: BEGIN