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 1142: ,p_header_rec In OE_ORDER_PUB.HEADER_REC_TYPE := OE_Order_PUB.G_MISS_HEADER_REC

1138: END RecordLineHist;
1139:
1140: Procedure RecordHeaderHist
1141: (p_header_id In Number
1142: ,p_header_rec In OE_ORDER_PUB.HEADER_REC_TYPE := OE_Order_PUB.G_MISS_HEADER_REC
1143: ,p_hist_type_code In Varchar2
1144: ,p_reason_code In varchar2
1145: ,p_comments IN Varchar2
1146: ,p_audit_flag IN Varchar2 := null

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

1152: ,p_wf_result_code IN Varchar2 := null
1153: ,p_changed_attribute IN varchar2 := null
1154: ,x_return_status Out NOCOPY /* file.sql.39 change */ Varchar2
1155: ) IS
1156: l_header_rec OE_ORDER_PUB.HEADER_REC_TYPE := OE_Order_PUB.G_MISS_HEADER_REC;
1157: l_credit_card_number varchar2(10);
1158: l_credit_card_code varchar2(10);
1159: l_instrument_id number;
1160: l_credit_card_holder_name varchar2(10);

Line 1629: ,p_header_scredit_rec In OE_ORDER_PUB.HEADER_SCREDIT_REC_TYPE

1625: END RecordHeaderHist;
1626:
1627: Procedure RecordHSCreditHist
1628: (p_header_scredit_id In Number
1629: ,p_header_scredit_rec In OE_ORDER_PUB.HEADER_SCREDIT_REC_TYPE
1630: := OE_Order_PUB.G_MISS_HEADER_SCREDIT_REC
1631: ,p_hist_type_code In Varchar2
1632: ,p_reason_code In varchar2
1633: ,p_comments IN Varchar2

Line 1630: := OE_Order_PUB.G_MISS_HEADER_SCREDIT_REC

1626:
1627: Procedure RecordHSCreditHist
1628: (p_header_scredit_id In Number
1629: ,p_header_scredit_rec In OE_ORDER_PUB.HEADER_SCREDIT_REC_TYPE
1630: := OE_Order_PUB.G_MISS_HEADER_SCREDIT_REC
1631: ,p_hist_type_code In Varchar2
1632: ,p_reason_code In varchar2
1633: ,p_comments IN Varchar2
1634: ,p_audit_flag IN Varchar2 := null

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

1639: ,p_wf_activity_code IN Varchar2 := null
1640: ,p_wf_result_code IN Varchar2 := null
1641: ,x_return_status Out NOCOPY /* file.sql.39 change */ Varchar2
1642: ) IS
1643: l_header_scredit_rec OE_ORDER_PUB.HEADER_SCREDIT_REC_TYPE := OE_Order_PUB.G_MISS_HEADER_SCREDIT_REC;
1644:
1645: --
1646: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1647: --

Line 1780: ,p_line_scredit_rec In OE_ORDER_PUB.LINE_SCREDIT_REC_TYPE

1776: END RecordHSCreditHist;
1777:
1778: Procedure RecordLSCreditHist
1779: (p_line_scredit_id In Number
1780: ,p_line_scredit_rec In OE_ORDER_PUB.LINE_SCREDIT_REC_TYPE
1781: := OE_Order_PUB.G_MISS_LINE_SCREDIT_REC
1782: ,p_hist_type_code In Varchar2
1783: ,p_reason_code In varchar2
1784: ,p_comments IN Varchar2

Line 1781: := OE_Order_PUB.G_MISS_LINE_SCREDIT_REC

1777:
1778: Procedure RecordLSCreditHist
1779: (p_line_scredit_id In Number
1780: ,p_line_scredit_rec In OE_ORDER_PUB.LINE_SCREDIT_REC_TYPE
1781: := OE_Order_PUB.G_MISS_LINE_SCREDIT_REC
1782: ,p_hist_type_code In Varchar2
1783: ,p_reason_code In varchar2
1784: ,p_comments IN Varchar2
1785: ,p_audit_flag IN Varchar2 := null

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

1790: ,p_wf_activity_code IN Varchar2 := null
1791: ,p_wf_result_code IN Varchar2 := null
1792: ,x_return_status Out NOCOPY /* file.sql.39 change */ Varchar2
1793: ) IS
1794: l_line_scredit_rec OE_ORDER_PUB.LINE_SCREDIT_REC_TYPE := OE_Order_PUB.G_MISS_LINE_SCREDIT_REC;
1795: --
1796: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1797: --
1798: BEGIN

Line 1931: ,p_header_adj_rec In OE_ORDER_PUB.HEADER_ADJ_REC_TYPE

1927: END RecordLSCreditHist;
1928:
1929: Procedure RecordHPAdjHist
1930: (p_header_adj_id In Number
1931: ,p_header_adj_rec In OE_ORDER_PUB.HEADER_ADJ_REC_TYPE
1932: := OE_Order_PUB.G_MISS_HEADER_ADJ_REC
1933: ,p_hist_type_code In Varchar2
1934: ,p_reason_code In varchar2
1935: ,p_comments IN Varchar2

Line 1932: := OE_Order_PUB.G_MISS_HEADER_ADJ_REC

1928:
1929: Procedure RecordHPAdjHist
1930: (p_header_adj_id In Number
1931: ,p_header_adj_rec In OE_ORDER_PUB.HEADER_ADJ_REC_TYPE
1932: := OE_Order_PUB.G_MISS_HEADER_ADJ_REC
1933: ,p_hist_type_code In Varchar2
1934: ,p_reason_code In varchar2
1935: ,p_comments IN Varchar2
1936: ,p_audit_flag IN Varchar2 := null

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

1941: ,p_wf_activity_code IN Varchar2 := null
1942: ,p_wf_result_code IN Varchar2 := null
1943: ,x_return_status Out NOCOPY /* file.sql.39 change */ Varchar2
1944: ) IS
1945: l_header_adj_rec OE_ORDER_PUB.HEADER_ADJ_REC_TYPE := OE_Order_PUB.G_MISS_HEADER_ADJ_REC;
1946: --
1947: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1948: --
1949: BEGIN

Line 2212: ,p_line_adj_rec In OE_ORDER_PUB.LINE_ADJ_REC_TYPE

2208: END RecordHPAdjHist;
2209:
2210: Procedure RecordLPAdjHist
2211: (p_line_adj_id In Number
2212: ,p_line_adj_rec In OE_ORDER_PUB.LINE_ADJ_REC_TYPE
2213: := OE_Order_PUB.G_MISS_LINE_ADJ_REC
2214: ,p_hist_type_code In Varchar2
2215: ,p_reason_code In varchar2
2216: ,p_comments IN Varchar2

Line 2213: := OE_Order_PUB.G_MISS_LINE_ADJ_REC

2209:
2210: Procedure RecordLPAdjHist
2211: (p_line_adj_id In Number
2212: ,p_line_adj_rec In OE_ORDER_PUB.LINE_ADJ_REC_TYPE
2213: := OE_Order_PUB.G_MISS_LINE_ADJ_REC
2214: ,p_hist_type_code In Varchar2
2215: ,p_reason_code In varchar2
2216: ,p_comments IN Varchar2
2217: ,p_audit_flag IN Varchar2 := null

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

2222: ,p_wf_activity_code IN Varchar2 := null
2223: ,p_wf_result_code IN Varchar2 := null
2224: ,x_return_status Out NOCOPY /* file.sql.39 change */ Varchar2
2225: ) IS
2226: l_line_adj_rec OE_ORDER_PUB.LINE_ADJ_REC_TYPE := OE_Order_PUB.G_MISS_LINE_ADJ_REC;
2227: --
2228: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2229: --
2230: BEGIN