1 PACKAGE ECE_SPSO_X AS
2 -- $Header: ECSPSOXS.pls 120.1 2005/06/30 11:24:18 appldev ship $
3 /*#
4 * This package contains routines to populate additonal columns for
5 * 830/DELFOR planning schedule and 832/DELJIT shipping schedule flat files.
6 * @rep:scope internal
7 * @rep:product EC
8 * @rep:lifecycle active
9 * @rep:displayname Outbound Planning/Shipping Schedule (SPSO/SSSO) Extensible Architecture
10 * @rep:compatibility S
11 * @rep:category BUSINESS_ENTITY CHV_PLANNING_SCHEDULE
12 * @rep:category BUSINESS_ENTITY CHV_SHIPPING_SCHEDULE
13 */
14 /*#
15 * This procedure can be used to populate additional data
16 * in Header level.This procedure can be modified by the user to utilize
17 * the EDI Extension Tables.
18 * @param l_fkey Transaction Record ID
19 * @param l_plsql_tbl PL/SQL Table
20 * @rep:lifecycle active
21 * @rep:displayname Populate Outbound Shipping/Planning Schedule Header with Additional Columns
22 * @rep:compatibility S
23 */
24
25 Procedure populate_extension_headers(l_fkey IN NUMBER,
26 l_plsql_tbl IN ece_flatfile_pvt.Interface_tbl_type);
27 /*#
28 * This procedure can be used to populate additional data
29 * in Item level.This procedure can be modified by the user to utilize
30 * the EDI Extension Tables.
31 * @param l_fkey Transaction Record ID
32 * @param l_plsql_tbl PL/SQL Table
33 * @rep:lifecycle active
34 * @rep:displayname Populate Outbound Shipping/Planning Schedule Item with Additional Columns
35 * @rep:compatibility S
36 */
37
38 Procedure populate_extension_items(l_fkey IN NUMBER,
39 l_plsql_tbl IN ece_flatfile_pvt.Interface_tbl_type);
40
41 /* Bug 1742567
42 Modified the procedure populate_extension_item_det
43 to receive correct parameters
44 */
45
46 /*Procedure populate_extension_item_det(l_fkey IN NUMBER,
47 l_plsql_tbl IN ece_flatfile_pvt.Interface_tbl_type);*/
48 /*#
49 * This procedure can be used to populate additional data
50 * in Item Detail level.This procedure can be modified by the user to utilize
51 * the EDI Extension Tables.
52 * @param transaction_id Transaction ID
53 * @param schedule_id Schedule Id
54 * @param schedule_item_id Schedule Item Id
55 * @rep:lifecycle active
56 * @rep:displayname Populate Outbound Shipping/Planning Schedule Item Detail with Additional Columns
57 * @rep:compatibility S
58 */
59
60 Procedure populate_extension_item_det(transaction_id IN NUMBER,
61 schedule_id IN NUMBER,
62 schedule_item_id IN NUMBER);
63 /*#
64 * This procedure can be used to populate additional data
65 * in Shipment Detail level.This procedure can be modified by the user to utilize
66 * the EDI Extension Tables.
67 * @param transaction_id Transaction ID
68 * @param schedule_id Schedule Id
69 * @param schedule_item_id Schedule Item Id
70 * @param schedule_item_detail_sequence Schedule Item Detail Sequence
71 * @rep:lifecycle active
72 * @rep:displayname Populate Outbound Shipping/Planning Schedule Shipment with Additional Columns
73 * @rep:compatibility S
74 */
75
76 Procedure populate_extension_ship_det(transaction_id IN NUMBER,
77 schedule_id IN NUMBER,
78 schedule_item_id IN NUMBER,
79 schedule_item_detail_sequence IN NUMBER);
80
81 end ECE_SPSO_X;