eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSI_ITEM_INSTANCE_VLD_PVT dependencies on CSI_DATASTRUCTURES_PUB

Line 325: p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec,

321: /*----------------------------------------------------*/
322:
323: PROCEDURE Validate_org_dependent_params
324: (
325: p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec,
326: p_txn_rec IN csi_datastructures_pub.transaction_rec,
327: l_return_value IN OUT NOCOPY BOOLEAN
328: ) IS
329:

Line 326: p_txn_rec IN csi_datastructures_pub.transaction_rec,

322:
323: PROCEDURE Validate_org_dependent_params
324: (
325: p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec,
326: p_txn_rec IN csi_datastructures_pub.transaction_rec,
327: l_return_value IN OUT NOCOPY BOOLEAN
328: ) IS
329:
330: BEGIN

Line 1092: p_txn_rec IN csi_datastructures_pub.transaction_rec,

1088: p_inv_org_id IN NUMBER,
1089: p_inv_item_id IN NUMBER,
1090: p_serial_number IN VARCHAR2,
1091: p_mfg_serial_number_flag IN VARCHAR2,
1092: p_txn_rec IN csi_datastructures_pub.transaction_rec,
1093: p_creation_complete_flag IN OUT NOCOPY VARCHAR2,
1094: p_location_type_code IN VARCHAR2, -- Added by sk on 09/13/01
1095: p_srl_control_code IN NUMBER,
1096: p_instance_id IN NUMBER, -- Bug # 2342885

Line 1689: p_txn_rec IN csi_datastructures_pub.transaction_rec,

1685: p_inv_org_id IN NUMBER,
1686: p_inv_item_id IN NUMBER,
1687: p_lot_number IN VARCHAR2,
1688: p_mfg_serial_number_flag IN VARCHAR2,
1689: p_txn_rec IN csi_datastructures_pub.transaction_rec,
1690: p_creation_complete_flag IN OUT NOCOPY VARCHAR2,
1691: p_lot_control_code IN NUMBER,
1692: l_return_value IN OUT NOCOPY BOOLEAN
1693: ) IS

Line 2473: FUNCTION validate_uniqueness(p_instance_rec csi_datastructures_pub.instance_rec,

2469: /* This function checks for the uniqueness of the */
2470: /* party owner */
2471: /*-----------------------------------------------------*/
2472:
2473: FUNCTION validate_uniqueness(p_instance_rec csi_datastructures_pub.instance_rec,
2474: p_party_rec csi_datastructures_pub.party_rec,
2475: p_srl_control_code NUMBER,
2476: p_csi_txn_type_id NUMBER )
2477: RETURN BOOLEAN IS

Line 2474: p_party_rec csi_datastructures_pub.party_rec,

2470: /* party owner */
2471: /*-----------------------------------------------------*/
2472:
2473: FUNCTION validate_uniqueness(p_instance_rec csi_datastructures_pub.instance_rec,
2474: p_party_rec csi_datastructures_pub.party_rec,
2475: p_srl_control_code NUMBER,
2476: p_csi_txn_type_id NUMBER )
2477: RETURN BOOLEAN IS
2478:

Line 2627: PROCEDURE get_merge_rec (p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec,

2623: /* This procedure is used to validate the values */
2624: /* passed to the update_item_instance */
2625: /*-----------------------------------------------------*/
2626:
2627: PROCEDURE get_merge_rec (p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec,
2628: l_curr_instance_rec IN csi_datastructures_pub.instance_rec,
2629: l_get_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec
2630: )
2631: IS

Line 2628: l_curr_instance_rec IN csi_datastructures_pub.instance_rec,

2624: /* passed to the update_item_instance */
2625: /*-----------------------------------------------------*/
2626:
2627: PROCEDURE get_merge_rec (p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec,
2628: l_curr_instance_rec IN csi_datastructures_pub.instance_rec,
2629: l_get_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec
2630: )
2631: IS
2632: BEGIN

Line 2629: l_get_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec

2625: /*-----------------------------------------------------*/
2626:
2627: PROCEDURE get_merge_rec (p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec,
2628: l_curr_instance_rec IN csi_datastructures_pub.instance_rec,
2629: l_get_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec
2630: )
2631: IS
2632: BEGIN
2633:

Line 3407: p_txn_rec IN csi_datastructures_pub.transaction_rec,

3403: p_inv_org_id IN NUMBER,
3404: p_inv_item_id IN NUMBER,
3405: p_serial_number IN VARCHAR2,
3406: p_mfg_serial_number_flag IN VARCHAR2,
3407: p_txn_rec IN csi_datastructures_pub.transaction_rec,
3408: p_location_type_code IN VARCHAR2, -- Added by sk on 09/13/01
3409: p_srl_control_code IN NUMBER,
3410: p_instance_usage_code IN VARCHAR2,
3411: p_instance_id IN NUMBER,

Line 3668: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN

3664: l_owner NUMBER := -1 ;
3665: l_count NUMBER := 0 ;
3666:
3667: BEGIN
3668: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
3669: csi_gen_utility_pvt.populate_install_param_rec;
3670: END IF;
3671: --
3672: l_int_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;

Line 3672: l_int_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;

3668: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
3669: csi_gen_utility_pvt.populate_install_param_rec;
3670: END IF;
3671: --
3672: l_int_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
3673: --
3674: BEGIN
3675: SELECT party_id
3676: INTO l_owner

Line 3841: p_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec,

3837: /*-----------------------------------------------------*/
3838:
3839: FUNCTION Val_and_get_inst_rec
3840: ( p_item_instance_id IN NUMBER,
3841: p_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec,
3842: p_stack_err_msg IN BOOLEAN
3843: ) RETURN BOOLEAN IS
3844: BEGIN
3845: SELECT

Line 4314: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN

4310: p_stack_err_msg BOOLEAN;
4311: l_location_lookup_type VARCHAR2(30) := 'CSI_INST_LOCATION_SOURCE_CODE';
4312: l_location_source_table VARCHAR2(30);
4313: BEGIN
4314: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
4315: csi_gen_utility_pvt.populate_install_param_rec;
4316: END IF;
4317: --
4318: IF csi_datastructures_pub.g_install_param_rec.fetch_flag = 'N' THEN

Line 4318: IF csi_datastructures_pub.g_install_param_rec.fetch_flag = 'N' THEN

4314: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
4315: csi_gen_utility_pvt.populate_install_param_rec;
4316: END IF;
4317: --
4318: IF csi_datastructures_pub.g_install_param_rec.fetch_flag = 'N' THEN
4319: FND_MESSAGE.SET_NAME('CSI','CSI_API_UNINSTALLED_PARAMETER');
4320: FND_MSG_PUB.ADD;
4321: l_return_value := FALSE;
4322: RETURN l_return_value;

Line 4814: (p_instance_header_tbl IN OUT NOCOPY csi_datastructures_pub.instance_header_tbl,

4810: /* associated instances of an instance of */
4811: /* instance item class link */
4812: /*-----------------------------------------------------------*/
4813: PROCEDURE get_link_locations
4814: (p_instance_header_tbl IN OUT NOCOPY csi_datastructures_pub.instance_header_tbl,
4815: x_return_status OUT NOCOPY VARCHAR2
4816: ) IS
4817: l_object_id NUMBER;
4818: l_subject_id NUMBER;

Line 4819: l_header_tbl csi_datastructures_pub.instance_header_tbl ;

4815: x_return_status OUT NOCOPY VARCHAR2
4816: ) IS
4817: l_object_id NUMBER;
4818: l_subject_id NUMBER;
4819: l_header_tbl csi_datastructures_pub.instance_header_tbl ;
4820: l_temp_header_tbl csi_datastructures_pub.instance_header_tbl ;
4821: l_link_type VARCHAR2(30);
4822: i NUMBER;
4823:

Line 4820: l_temp_header_tbl csi_datastructures_pub.instance_header_tbl ;

4816: ) IS
4817: l_object_id NUMBER;
4818: l_subject_id NUMBER;
4819: l_header_tbl csi_datastructures_pub.instance_header_tbl ;
4820: l_temp_header_tbl csi_datastructures_pub.instance_header_tbl ;
4821: l_link_type VARCHAR2(30);
4822: i NUMBER;
4823:
4824: CURSOR link_csr(p_instance_id NUMBER) IS

Line 4928: ( p_instance_rec IN csi_datastructures_pub.instance_rec

4924: END LOOP;
4925: END get_link_locations;
4926:
4927: PROCEDURE Call_batch_validate
4928: ( p_instance_rec IN csi_datastructures_pub.instance_rec
4929: ,p_config_hdr_id IN NUMBER
4930: ,p_config_rev_nbr IN NUMBER
4931: ,x_config_hdr_id OUT NOCOPY NUMBER
4932: ,x_config_rev_nbr OUT NOCOPY NUMBER

Line 5064: ( p_instance_rec IN csi_datastructures_pub.instance_rec

5060: /* will be checked against this list for further processing */
5061: /*-----------------------------------------------------------*/
5062:
5063: PROCEDURE Check_Prior_Txn
5064: ( p_instance_rec IN csi_datastructures_pub.instance_rec
5065: ,p_txn_rec IN csi_datastructures_pub.transaction_rec
5066: ,p_prior_txn_id OUT NOCOPY NUMBER
5067: ,p_mode IN VARCHAR2
5068: ,x_return_status OUT NOCOPY VARCHAR2

Line 5065: ,p_txn_rec IN csi_datastructures_pub.transaction_rec

5061: /*-----------------------------------------------------------*/
5062:
5063: PROCEDURE Check_Prior_Txn
5064: ( p_instance_rec IN csi_datastructures_pub.instance_rec
5065: ,p_txn_rec IN csi_datastructures_pub.transaction_rec
5066: ,p_prior_txn_id OUT NOCOPY NUMBER
5067: ,p_mode IN VARCHAR2
5068: ,x_return_status OUT NOCOPY VARCHAR2
5069: ) AS

Line 5165: l_mtl_txn_tbl csi_datastructures_pub.mtl_txn_tbl;

5161: l_xfer_mtl_txn_id NUMBER;
5162: l_src_txn_date DATE;
5163: l_cur_mtl_txn_id number;
5164: l_cur_mtl_txn_date DATE;
5165: l_mtl_txn_tbl csi_datastructures_pub.mtl_txn_tbl;
5166: l_txn_line_detail_id NUMBER;
5167: l_order_number NUMBER;
5168: l_line_number NUMBER;
5169: l_error_found varchar2(1);

Line 5189: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN

5185:
5186: IF p_instance_rec.inventory_item_id is NOT NULL AND p_instance_rec.inventory_item_id <> FND_API.G_MISS_NUM
5187: AND p_instance_rec.serial_number is NOT NULL AND p_instance_rec.serial_number <> FND_API.G_MISS_CHAR
5188: THEN
5189: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
5190: csi_gen_utility_pvt.populate_install_param_rec;
5191: END IF;
5192:
5193: l_txn_seq_start_date := nvl(csi_datastructures_pub.g_install_param_rec.txn_seq_start_date,

Line 5193: l_txn_seq_start_date := nvl(csi_datastructures_pub.g_install_param_rec.txn_seq_start_date,

5189: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
5190: csi_gen_utility_pvt.populate_install_param_rec;
5191: END IF;
5192:
5193: l_txn_seq_start_date := nvl(csi_datastructures_pub.g_install_param_rec.txn_seq_start_date,
5194: csi_datastructures_pub.g_install_param_rec.freeze_date);
5195:
5196: IF l_txn_seq_start_date IS NULL THEN
5197: FND_MESSAGE.SET_NAME('CSI','CSI_API_UNINSTALLED_PARAMETER');

Line 5194: csi_datastructures_pub.g_install_param_rec.freeze_date);

5190: csi_gen_utility_pvt.populate_install_param_rec;
5191: END IF;
5192:
5193: l_txn_seq_start_date := nvl(csi_datastructures_pub.g_install_param_rec.txn_seq_start_date,
5194: csi_datastructures_pub.g_install_param_rec.freeze_date);
5195:
5196: IF l_txn_seq_start_date IS NULL THEN
5197: FND_MESSAGE.SET_NAME('CSI','CSI_API_UNINSTALLED_PARAMETER');
5198: FND_MSG_PUB.ADD;

Line 5229: -- ,p_freeze_date => csi_datastructures_pub.g_install_param_rec.freeze_date);

5225: csi_gen_utility_pvt.put_line(' l_cur_mtl_txn_date : '||l_cur_mtl_txn_date);
5226:
5227: IF p_mode <> 'CREATE' THEN -- Bug 14712665
5228: -- decode_queue(p_pending_txn_tbl => l_pending_txn_tbl
5229: -- ,p_freeze_date => csi_datastructures_pub.g_install_param_rec.freeze_date);
5230: -- For 'UPDATE' mode get the transactions starting from the src txn date used for instance creation.
5231: -- Bug # 4018629
5232: --ELSE -- Bug 14712665
5233: l_min_txn_id := NULL;

Line 5334: ,p_freeze_date => csi_datastructures_pub.g_install_param_rec.freeze_date

5330: AND l_mtl_txn_tbl(l_ind_c).creation_date < l_cur_mtl_txn_date
5331: AND l_mtl_txn_tbl(l_ind_c).transaction_id <> l_cur_mtl_txn_id
5332: THEN
5333: decode_queue(p_pending_txn_tbl => l_pending_txn_tbl
5334: ,p_freeze_date => csi_datastructures_pub.g_install_param_rec.freeze_date
5335: ,p_source_transaction_date => p_txn_rec.source_transaction_date);
5336: EXIT;
5337: END IF;
5338: l_temp_count := l_temp_count +1;

Line 5609: param_name csi_datastructures_pub.parameter_name;

5605: /*TYPE param_name_type IS TABLE OF VARCHAR2(30)
5606: INDEX BY BINARY_INTEGER;
5607: TYPE param_value_type IS TABLE OF VARCHAR2(200)
5608: INDEX BY BINARY_INTEGER;*/
5609: param_name csi_datastructures_pub.parameter_name;
5610: param_value csi_datastructures_pub.parameter_value;
5611: l_rec_index BINARY_INTEGER;
5612: -- SPC specific params
5613: l_database_id VARCHAR2(100);

Line 5610: param_value csi_datastructures_pub.parameter_value;

5606: INDEX BY BINARY_INTEGER;
5607: TYPE param_value_type IS TABLE OF VARCHAR2(200)
5608: INDEX BY BINARY_INTEGER;*/
5609: param_name csi_datastructures_pub.parameter_name;
5610: param_value csi_datastructures_pub.parameter_value;
5611: l_rec_index BINARY_INTEGER;
5612: -- SPC specific params
5613: l_database_id VARCHAR2(100);
5614: l_save_config_behavior VARCHAR2(30):= 'new_config';

Line 6195: p_instance_rec IN csi_datastructures_pub.instance_rec,

6191: RETURN TRUE;
6192: END pending_in_oi_or_tld;
6193:
6194: PROCEDURE validate_serial_for_upd(
6195: p_instance_rec IN csi_datastructures_pub.instance_rec,
6196: p_txn_rec IN csi_datastructures_pub.transaction_rec,
6197: p_old_serial_number IN varchar2,
6198: x_return_status OUT nocopy varchar2)
6199: IS

Line 6196: p_txn_rec IN csi_datastructures_pub.transaction_rec,

6192: END pending_in_oi_or_tld;
6193:
6194: PROCEDURE validate_serial_for_upd(
6195: p_instance_rec IN csi_datastructures_pub.instance_rec,
6196: p_txn_rec IN csi_datastructures_pub.transaction_rec,
6197: p_old_serial_number IN varchar2,
6198: x_return_status OUT nocopy varchar2)
6199: IS
6200:

Line 6422: x_mtl_txn_tbl OUT nocopy csi_datastructures_pub.mtl_txn_tbl)

6418: PROCEDURE get_mtl_txn_for_srl(
6419: p_transaction_id IN number, -- Added for bug#14835893
6420: p_inventory_item_id IN number,
6421: p_serial_number IN varchar2,
6422: x_mtl_txn_tbl OUT nocopy csi_datastructures_pub.mtl_txn_tbl)
6423: IS
6424:
6425: l_mtl_txn_id number;
6426: --l_lot_number varchar2(30);

Line 6428: l_mtl_txn_tbl csi_datastructures_pub.mtl_txn_tbl;

6424:
6425: l_mtl_txn_id number;
6426: --l_lot_number varchar2(30);
6427: l_lot_number varchar2(80); --bug 10279935
6428: l_mtl_txn_tbl csi_datastructures_pub.mtl_txn_tbl;
6429: l_ind binary_integer := 0;
6430: x_ind binary_integer := 0;
6431: l_txn_seq_start_date date;
6432:

Line 6452: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN

6448: ORDER BY mut.creation_date desc, mut.transaction_id desc;
6449:
6450: BEGIN
6451:
6452: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
6453: csi_gen_utility_pvt.populate_install_param_rec;
6454: END IF;
6455:
6456: l_txn_seq_start_date := csi_datastructures_pub.g_install_param_rec.txn_seq_start_date;

Line 6456: l_txn_seq_start_date := csi_datastructures_pub.g_install_param_rec.txn_seq_start_date;

6452: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
6453: csi_gen_utility_pvt.populate_install_param_rec;
6454: END IF;
6455:
6456: l_txn_seq_start_date := csi_datastructures_pub.g_install_param_rec.txn_seq_start_date;
6457: IF l_txn_seq_start_date is null THEN
6458: l_txn_seq_start_date := csi_datastructures_pub.g_install_param_rec.freeze_date;
6459: END IF;
6460:

Line 6458: l_txn_seq_start_date := csi_datastructures_pub.g_install_param_rec.freeze_date;

6454: END IF;
6455:
6456: l_txn_seq_start_date := csi_datastructures_pub.g_install_param_rec.txn_seq_start_date;
6457: IF l_txn_seq_start_date is null THEN
6458: l_txn_seq_start_date := csi_datastructures_pub.g_install_param_rec.freeze_date;
6459: END IF;
6460:
6461: IF l_txn_seq_start_date is null THEN
6462: fnd_message.set_name('CSI','CSI_API_UNINSTALLED_PARAMETER');