DBA Data[Home] [Help]

APPS.INV_LOGICAL_TRANSACTIONS_PVT dependencies on INV_LOGICAL_TRANSACTION_GLOBAL

Line 26: , p_mtl_trx_tbl IN inv_logical_transaction_global.mtl_trx_tbl_type

22: , x_msg_count OUT NOCOPY NUMBER
23: , x_msg_data OUT NOCOPY VARCHAR2
24: , p_api_version_number IN NUMBER
25: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
26: , p_mtl_trx_tbl IN inv_logical_transaction_global.mtl_trx_tbl_type
27: , p_validation_level IN VARCHAR2
28: , p_logical_trx_type_code IN NUMBER
29: ) IS
30:

Line 79: (INV_LOGICAL_TRANSACTION_GLOBAL.G_LOGTRXCODE_DSRECEIPT,

75:
76: --1. Validate logical transaction type codes
77: IF (p_logical_trx_type_code IS NULL OR
78: (p_logical_trx_type_code NOT IN
79: (INV_LOGICAL_TRANSACTION_GLOBAL.G_LOGTRXCODE_DSRECEIPT,
80: INV_LOGICAL_TRANSACTION_GLOBAL.G_LOGTRXCODE_DSDELIVER,
81: INV_LOGICAL_TRANSACTION_GLOBAL.G_LOGTRXCODE_GLOBPROCRTV,
82: INV_LOGICAL_TRANSACTION_GLOBAL.G_LOGTRXCODE_RETROPRICEUPD,
83: INV_LOGICAL_TRANSACTION_GLOBAL.G_LOGTRXCODE_RMASOISSUE))) THEN

Line 80: INV_LOGICAL_TRANSACTION_GLOBAL.G_LOGTRXCODE_DSDELIVER,

76: --1. Validate logical transaction type codes
77: IF (p_logical_trx_type_code IS NULL OR
78: (p_logical_trx_type_code NOT IN
79: (INV_LOGICAL_TRANSACTION_GLOBAL.G_LOGTRXCODE_DSRECEIPT,
80: INV_LOGICAL_TRANSACTION_GLOBAL.G_LOGTRXCODE_DSDELIVER,
81: INV_LOGICAL_TRANSACTION_GLOBAL.G_LOGTRXCODE_GLOBPROCRTV,
82: INV_LOGICAL_TRANSACTION_GLOBAL.G_LOGTRXCODE_RETROPRICEUPD,
83: INV_LOGICAL_TRANSACTION_GLOBAL.G_LOGTRXCODE_RMASOISSUE))) THEN
84:

Line 81: INV_LOGICAL_TRANSACTION_GLOBAL.G_LOGTRXCODE_GLOBPROCRTV,

77: IF (p_logical_trx_type_code IS NULL OR
78: (p_logical_trx_type_code NOT IN
79: (INV_LOGICAL_TRANSACTION_GLOBAL.G_LOGTRXCODE_DSRECEIPT,
80: INV_LOGICAL_TRANSACTION_GLOBAL.G_LOGTRXCODE_DSDELIVER,
81: INV_LOGICAL_TRANSACTION_GLOBAL.G_LOGTRXCODE_GLOBPROCRTV,
82: INV_LOGICAL_TRANSACTION_GLOBAL.G_LOGTRXCODE_RETROPRICEUPD,
83: INV_LOGICAL_TRANSACTION_GLOBAL.G_LOGTRXCODE_RMASOISSUE))) THEN
84:
85: IF (l_debug = 1) THEN

Line 82: INV_LOGICAL_TRANSACTION_GLOBAL.G_LOGTRXCODE_RETROPRICEUPD,

78: (p_logical_trx_type_code NOT IN
79: (INV_LOGICAL_TRANSACTION_GLOBAL.G_LOGTRXCODE_DSRECEIPT,
80: INV_LOGICAL_TRANSACTION_GLOBAL.G_LOGTRXCODE_DSDELIVER,
81: INV_LOGICAL_TRANSACTION_GLOBAL.G_LOGTRXCODE_GLOBPROCRTV,
82: INV_LOGICAL_TRANSACTION_GLOBAL.G_LOGTRXCODE_RETROPRICEUPD,
83: INV_LOGICAL_TRANSACTION_GLOBAL.G_LOGTRXCODE_RMASOISSUE))) THEN
84:
85: IF (l_debug = 1) THEN
86: debug_print('Invalid Logical Transaction Type Code', 9);

Line 83: INV_LOGICAL_TRANSACTION_GLOBAL.G_LOGTRXCODE_RMASOISSUE))) THEN

79: (INV_LOGICAL_TRANSACTION_GLOBAL.G_LOGTRXCODE_DSRECEIPT,
80: INV_LOGICAL_TRANSACTION_GLOBAL.G_LOGTRXCODE_DSDELIVER,
81: INV_LOGICAL_TRANSACTION_GLOBAL.G_LOGTRXCODE_GLOBPROCRTV,
82: INV_LOGICAL_TRANSACTION_GLOBAL.G_LOGTRXCODE_RETROPRICEUPD,
83: INV_LOGICAL_TRANSACTION_GLOBAL.G_LOGTRXCODE_RMASOISSUE))) THEN
84:
85: IF (l_debug = 1) THEN
86: debug_print('Invalid Logical Transaction Type Code', 9);
87: END IF;

Line 560: IF (p_logical_trx_type_code = INV_LOGICAL_TRANSACTION_GLOBAL.G_LOGTRXCODE_DSDELIVER AND

556:
557:
558: --11. Validate transaction source type for sales order tied to drop
559: -- ment transactions.
560: IF (p_logical_trx_type_code = INV_LOGICAL_TRANSACTION_GLOBAL.G_LOGTRXCODE_DSDELIVER AND
561: (p_mtl_trx_tbl(i).transaction_source_type_id = inv_globals.g_sourcetype_salesorder AND
562: p_mtl_trx_tbl(i).transaction_action_id = inv_globals.g_action_logicalissue)) THEN
563: -- drop shipments across multiple OUs
564: -- get the sales order tied to the logical transaction

Line 1020: (p_logical_trx_type_code = INV_LOGICAL_TRANSACTION_GLOBAL.G_LOGTRXCODE_DSRECEIPT) THEN

1016: AND p_mtl_trx_tbl(i).transaction_action_id = inv_globals.g_action_logicalreceipt) OR
1017: (p_mtl_trx_tbl(i).transaction_source_type_id = inv_globals.g_sourcetype_purchaseorder AND
1018: p_mtl_trx_tbl(i).transaction_action_id =
1019: inv_globals.g_action_logicalissue)) AND
1020: (p_logical_trx_type_code = INV_LOGICAL_TRANSACTION_GLOBAL.G_LOGTRXCODE_DSRECEIPT) THEN
1021:
1022: IF ((p_mtl_trx_tbl(i).transaction_source_id IS NULL) OR (p_mtl_trx_tbl(i).rcv_transaction_id IS NULL)) THEN
1023:
1024: IF (l_debug = 1) THEN

Line 1071: (INV_LOGICAL_TRANSACTION_GLOBAL.G_LOGTRXCODE_DSDELIVER,

1067:
1068: l_count := 0;
1069:
1070: IF (p_logical_trx_type_code IN
1071: (INV_LOGICAL_TRANSACTION_GLOBAL.G_LOGTRXCODE_DSDELIVER,
1072: INV_LOGICAL_TRANSACTION_GLOBAL.G_LOGTRXCODE_RMASOISSUE)) THEN
1073:
1074: IF (p_mtl_trx_tbl(i).trx_source_line_id IS NULL) THEN
1075:

Line 1072: INV_LOGICAL_TRANSACTION_GLOBAL.G_LOGTRXCODE_RMASOISSUE)) THEN

1068: l_count := 0;
1069:
1070: IF (p_logical_trx_type_code IN
1071: (INV_LOGICAL_TRANSACTION_GLOBAL.G_LOGTRXCODE_DSDELIVER,
1072: INV_LOGICAL_TRANSACTION_GLOBAL.G_LOGTRXCODE_RMASOISSUE)) THEN
1073:
1074: IF (p_mtl_trx_tbl(i).trx_source_line_id IS NULL) THEN
1075:
1076: IF (l_debug = 1) THEN

Line 1223: , p_mtl_trx_tbl IN inv_logical_transaction_global.mtl_trx_tbl_type

1219: , x_msg_count OUT NOCOPY NUMBER
1220: , x_msg_data OUT NOCOPY VARCHAR2
1221: , p_api_version_number IN NUMBER
1222: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
1223: , p_mtl_trx_tbl IN inv_logical_transaction_global.mtl_trx_tbl_type
1224: , p_logical_trx_type_code IN NUMBER
1225:
1226:
1227: )

Line 1229: -- p_mtl_trx_tbl(i) inv_logical_transaction_global.mtl_trx_tbl_type := p_mtl_trx_tbl;

1225:
1226:
1227: )
1228: IS
1229: -- p_mtl_trx_tbl(i) inv_logical_transaction_global.mtl_trx_tbl_type := p_mtl_trx_tbl;
1230: l_debug NUMBER := NVL(fnd_profile.value('INV_DEBUG_TRACE'),0);
1231: l_api_version_number CONSTANT NUMBER := 1.0;
1232: l_api_name CONSTANT VARCHAR2(30) := 'Inv_Mmt_Insert';
1233: l_logical_transaction NUMBER := 1;