DBA Data[Home] [Help]

APPS.CSP_TRANSACTIONS_PUB_W dependencies on CSP_TRANSACTIONS_PUB

Line 1: package body csp_transactions_pub_w as

1: package body csp_transactions_pub_w as
2: /* $Header: csptppwb.pls 120.5.12020000.2 2012/07/20 10:00:18 rrajain ship $ */
3: rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4: rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5: rosetta_g_mistake_date_high date := to_date('01/01/+4710', 'MM/DD/SYYYY');

Line 16: procedure rosetta_table_copy_in_p2(t out nocopy csp_transactions_pub.trans_items_tbl_type, a0 JTF_NUMBER_TABLE

12: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13: return d;
14: end;
15:
16: procedure rosetta_table_copy_in_p2(t out nocopy csp_transactions_pub.trans_items_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_VARCHAR2_TABLE_100
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_VARCHAR2_TABLE_100

Line 75: procedure rosetta_table_copy_out_p2(t csp_transactions_pub.trans_items_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

71: end loop;
72: end if;
73: end if;
74: end rosetta_table_copy_in_p2;
75: procedure rosetta_table_copy_out_p2(t csp_transactions_pub.trans_items_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
76: , a1 out nocopy JTF_VARCHAR2_TABLE_100
77: , a2 out nocopy JTF_NUMBER_TABLE
78: , a3 out nocopy JTF_VARCHAR2_TABLE_100
79: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 199: procedure rosetta_table_copy_in_p17(t out nocopy csp_transactions_pub.csparray, a0 JTF_NUMBER_TABLE) as

195: end if;
196: end if;
197: end rosetta_table_copy_out_p2;
198:
199: procedure rosetta_table_copy_in_p17(t out nocopy csp_transactions_pub.csparray, a0 JTF_NUMBER_TABLE) as
200: ddindx binary_integer; indx binary_integer;
201: begin
202: if a0 is null then
203: t := null;

Line 205: t := csp_transactions_pub.csparray();

201: begin
202: if a0 is null then
203: t := null;
204: elsif a0.count = 0 then
205: t := csp_transactions_pub.csparray();
206: else
207: if a0.count > 0 then
208: t := csp_transactions_pub.csparray();
209: t.extend(a0.count);

Line 208: t := csp_transactions_pub.csparray();

204: elsif a0.count = 0 then
205: t := csp_transactions_pub.csparray();
206: else
207: if a0.count > 0 then
208: t := csp_transactions_pub.csparray();
209: t.extend(a0.count);
210: indx := a0.first;
211: ddindx := 1;
212: while true loop

Line 223: procedure rosetta_table_copy_out_p17(t csp_transactions_pub.csparray, a0 out nocopy JTF_NUMBER_TABLE) as

219: end loop;
220: end if;
221: end if;
222: end rosetta_table_copy_in_p17;
223: procedure rosetta_table_copy_out_p17(t csp_transactions_pub.csparray, a0 out nocopy JTF_NUMBER_TABLE) as
224: ddindx binary_integer; indx binary_integer;
225: begin
226: if t is null then
227: a0 := null;

Line 306: csp_transactions_pub.create_move_order_header(px_header_id,

302:
303:
304:
305: -- here's the delegated call to the old PL/SQL routine
306: csp_transactions_pub.create_move_order_header(px_header_id,
307: p_request_number,
308: p_api_version,
309: p_init_msg_list,
310: p_commit,

Line 423: csp_transactions_pub.create_move_order_line(p_api_version,

419:
420:
421:
422: -- here's the delegated call to the old PL/SQL routine
423: csp_transactions_pub.create_move_order_line(p_api_version,
424: p_init_msg_list,
425: p_commit,
426: px_line_id,
427: p_header_id,

Line 579: csp_transactions_pub.transact_material(p_api_version,

575:
576:
577:
578: -- here's the delegated call to the old PL/SQL routine
579: csp_transactions_pub.transact_material(p_api_version,
580: p_init_msg_list,
581: p_commit,
582: px_transaction_id,
583: px_transaction_header_id,

Line 693: csp_transactions_pub.transact_temp_record(p_api_version_number,

689:
690:
691:
692: -- here's the delegated call to the old PL/SQL routine
693: csp_transactions_pub.transact_temp_record(p_api_version_number,
694: p_init_msg_list,
695: p_commit,
696: p_validation_level,
697: p_transaction_temp_id,

Line 747: ddp_trans_items csp_transactions_pub.trans_items_tbl_type;

743: , x_msg_data out nocopy VARCHAR2
744: )
745:
746: as
747: ddp_trans_items csp_transactions_pub.trans_items_tbl_type;
748: ddindx binary_integer; indx binary_integer;
749: begin
750:
751: -- copy data to the local IN or IN-OUT args, if any

Line 755: csp_transactions_pub_w.rosetta_table_copy_in_p2(ddp_trans_items, p3_a0

751: -- copy data to the local IN or IN-OUT args, if any
752:
753:
754:
755: csp_transactions_pub_w.rosetta_table_copy_in_p2(ddp_trans_items, p3_a0
756: , p3_a1
757: , p3_a2
758: , p3_a3
759: , p3_a4

Line 783: csp_transactions_pub.transact_items_transfer(p_api_version_number,

779:
780:
781:
782: -- here's the delegated call to the old PL/SQL routine
783: csp_transactions_pub.transact_items_transfer(p_api_version_number,
784: p_init_msg_list,
785: p_commit,
786: ddp_trans_items,
787: p_trans_type_id,

Line 796: csp_transactions_pub_w.rosetta_table_copy_out_p2(ddp_trans_items, p3_a0

792: -- copy data back from the local variables to OUT or IN-OUT args, if any
793:
794:
795:
796: csp_transactions_pub_w.rosetta_table_copy_out_p2(ddp_trans_items, p3_a0
797: , p3_a1
798: , p3_a2
799: , p3_a3
800: , p3_a4

Line 854: ddp_trans_items csp_transactions_pub.trans_items_tbl_type;

850: , x_msg_data out nocopy VARCHAR2
851: )
852:
853: as
854: ddp_trans_items csp_transactions_pub.trans_items_tbl_type;
855: ddindx binary_integer; indx binary_integer;
856: begin
857:
858: -- copy data to the local IN or IN-OUT args, if any

Line 862: csp_transactions_pub_w.rosetta_table_copy_in_p2(ddp_trans_items, p3_a0

858: -- copy data to the local IN or IN-OUT args, if any
859:
860:
861:
862: csp_transactions_pub_w.rosetta_table_copy_in_p2(ddp_trans_items, p3_a0
863: , p3_a1
864: , p3_a2
865: , p3_a3
866: , p3_a4

Line 889: csp_transactions_pub.transact_subinv_transfer(p_api_version_number,

885:
886:
887:
888: -- here's the delegated call to the old PL/SQL routine
889: csp_transactions_pub.transact_subinv_transfer(p_api_version_number,
890: p_init_msg_list,
891: p_commit,
892: ddp_trans_items,
893: x_return_status,

Line 901: csp_transactions_pub_w.rosetta_table_copy_out_p2(ddp_trans_items, p3_a0

897: -- copy data back from the local variables to OUT or IN-OUT args, if any
898:
899:
900:
901: csp_transactions_pub_w.rosetta_table_copy_out_p2(ddp_trans_items, p3_a0
902: , p3_a1
903: , p3_a2
904: , p3_a3
905: , p3_a4

Line 959: ddp_trans_items csp_transactions_pub.trans_items_tbl_type;

955: , x_msg_data out nocopy VARCHAR2
956: )
957:
958: as
959: ddp_trans_items csp_transactions_pub.trans_items_tbl_type;
960: ddp_if_intransit boolean;
961: ddindx binary_integer; indx binary_integer;
962: begin
963:

Line 968: csp_transactions_pub_w.rosetta_table_copy_in_p2(ddp_trans_items, p3_a0

964: -- copy data to the local IN or IN-OUT args, if any
965:
966:
967:
968: csp_transactions_pub_w.rosetta_table_copy_in_p2(ddp_trans_items, p3_a0
969: , p3_a1
970: , p3_a2
971: , p3_a3
972: , p3_a4

Line 1002: csp_transactions_pub.transact_intorg_transfer(p_api_version_number,

998:
999:
1000:
1001: -- here's the delegated call to the old PL/SQL routine
1002: csp_transactions_pub.transact_intorg_transfer(p_api_version_number,
1003: p_init_msg_list,
1004: p_commit,
1005: ddp_trans_items,
1006: ddp_if_intransit,

Line 1015: csp_transactions_pub_w.rosetta_table_copy_out_p2(ddp_trans_items, p3_a0

1011: -- copy data back from the local variables to OUT or IN-OUT args, if any
1012:
1013:
1014:
1015: csp_transactions_pub_w.rosetta_table_copy_out_p2(ddp_trans_items, p3_a0
1016: , p3_a1
1017: , p3_a2
1018: , p3_a3
1019: , p3_a4

Line 1073: ddp_trans_items csp_transactions_pub.trans_items_tbl_type;

1069: , x_msg_data out nocopy VARCHAR2
1070: )
1071:
1072: as
1073: ddp_trans_items csp_transactions_pub.trans_items_tbl_type;
1074: ddp_date_required date;
1075: ddindx binary_integer; indx binary_integer;
1076: begin
1077:

Line 1079: csp_transactions_pub_w.rosetta_table_copy_in_p2(ddp_trans_items, p0_a0

1075: ddindx binary_integer; indx binary_integer;
1076: begin
1077:
1078: -- copy data to the local IN or IN-OUT args, if any
1079: csp_transactions_pub_w.rosetta_table_copy_in_p2(ddp_trans_items, p0_a0
1080: , p0_a1
1081: , p0_a2
1082: , p0_a3
1083: , p0_a4

Line 1110: csp_transactions_pub.create_move_order(ddp_trans_items,

1106:
1107:
1108:
1109: -- here's the delegated call to the old PL/SQL routine
1110: csp_transactions_pub.create_move_order(ddp_trans_items,
1111: ddp_date_required,
1112: p_comments,
1113: x_move_order_number,
1114: x_return_status,

Line 1119: csp_transactions_pub_w.rosetta_table_copy_out_p2(ddp_trans_items, p0_a0

1115: x_msg_count,
1116: x_msg_data);
1117:
1118: -- copy data back from the local variables to OUT or IN-OUT args, if any
1119: csp_transactions_pub_w.rosetta_table_copy_out_p2(ddp_trans_items, p0_a0
1120: , p0_a1
1121: , p0_a2
1122: , p0_a3
1123: , p0_a4

Line 1181: ddp_trans_record csp_transactions_pub.trans_items_rec_type;

1177: , x_msg_data out nocopy VARCHAR2
1178: )
1179:
1180: as
1181: ddp_trans_record csp_transactions_pub.trans_items_rec_type;
1182: ddindx binary_integer; indx binary_integer;
1183: begin
1184:
1185: -- copy data to the local IN or IN-OUT args, if any

Line 1217: csp_transactions_pub.receive_requirement_trans(p_trans_header_id,

1213:
1214:
1215:
1216: -- here's the delegated call to the old PL/SQL routine
1217: csp_transactions_pub.receive_requirement_trans(p_trans_header_id,
1218: p_trans_line_id,
1219: ddp_trans_record,
1220: p_trans_type,
1221: p_req_line_detail_id,

Line 1238: end csp_transactions_pub_w;

1234:
1235:
1236: end;
1237:
1238: end csp_transactions_pub_w;