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 324: p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec,

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

Line 325: p_txn_rec IN csi_datastructures_pub.transaction_rec,

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

Line 1091: p_txn_rec IN csi_datastructures_pub.transaction_rec,

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

Line 1645: p_txn_rec IN csi_datastructures_pub.transaction_rec,

1641: p_inv_org_id IN NUMBER,
1642: p_inv_item_id IN NUMBER,
1643: p_lot_number IN VARCHAR2,
1644: p_mfg_serial_number_flag IN VARCHAR2,
1645: p_txn_rec IN csi_datastructures_pub.transaction_rec,
1646: p_creation_complete_flag IN OUT NOCOPY VARCHAR2,
1647: p_lot_control_code IN NUMBER,
1648: l_return_value IN OUT NOCOPY BOOLEAN
1649: ) IS

Line 2428: FUNCTION validate_uniqueness(p_instance_rec csi_datastructures_pub.instance_rec,

2424: /* This function checks for the uniqueness of the */
2425: /* party owner */
2426: /*-----------------------------------------------------*/
2427:
2428: FUNCTION validate_uniqueness(p_instance_rec csi_datastructures_pub.instance_rec,
2429: p_party_rec csi_datastructures_pub.party_rec,
2430: p_srl_control_code NUMBER,
2431: p_csi_txn_type_id NUMBER )
2432: RETURN BOOLEAN IS

Line 2429: p_party_rec csi_datastructures_pub.party_rec,

2425: /* party owner */
2426: /*-----------------------------------------------------*/
2427:
2428: FUNCTION validate_uniqueness(p_instance_rec csi_datastructures_pub.instance_rec,
2429: p_party_rec csi_datastructures_pub.party_rec,
2430: p_srl_control_code NUMBER,
2431: p_csi_txn_type_id NUMBER )
2432: RETURN BOOLEAN IS
2433:

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

2571: /* This procedure is used to validate the values */
2572: /* passed to the update_item_instance */
2573: /*-----------------------------------------------------*/
2574:
2575: PROCEDURE get_merge_rec (p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec,
2576: l_curr_instance_rec IN csi_datastructures_pub.instance_rec,
2577: l_get_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec
2578: )
2579: IS

Line 2576: l_curr_instance_rec IN csi_datastructures_pub.instance_rec,

2572: /* passed to the update_item_instance */
2573: /*-----------------------------------------------------*/
2574:
2575: PROCEDURE get_merge_rec (p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec,
2576: l_curr_instance_rec IN csi_datastructures_pub.instance_rec,
2577: l_get_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec
2578: )
2579: IS
2580: BEGIN

Line 2577: l_get_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec

2573: /*-----------------------------------------------------*/
2574:
2575: PROCEDURE get_merge_rec (p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec,
2576: l_curr_instance_rec IN csi_datastructures_pub.instance_rec,
2577: l_get_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec
2578: )
2579: IS
2580: BEGIN
2581:

Line 3355: p_txn_rec IN csi_datastructures_pub.transaction_rec,

3351: p_inv_org_id IN NUMBER,
3352: p_inv_item_id IN NUMBER,
3353: p_serial_number IN VARCHAR2,
3354: p_mfg_serial_number_flag IN VARCHAR2,
3355: p_txn_rec IN csi_datastructures_pub.transaction_rec,
3356: p_location_type_code IN VARCHAR2, -- Added by sk on 09/13/01
3357: p_srl_control_code IN NUMBER,
3358: p_instance_usage_code IN VARCHAR2,
3359: p_instance_id IN NUMBER,

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

3585: l_owner NUMBER := -1 ;
3586: l_count NUMBER := 0 ;
3587:
3588: BEGIN
3589: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
3590: csi_gen_utility_pvt.populate_install_param_rec;
3591: END IF;
3592: --
3593: l_int_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;

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

3589: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
3590: csi_gen_utility_pvt.populate_install_param_rec;
3591: END IF;
3592: --
3593: l_int_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
3594: --
3595: BEGIN
3596: SELECT party_id
3597: INTO l_owner

Line 3759: p_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec,

3755: /*-----------------------------------------------------*/
3756:
3757: FUNCTION Val_and_get_inst_rec
3758: ( p_item_instance_id IN NUMBER,
3759: p_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec,
3760: p_stack_err_msg IN BOOLEAN
3761: ) RETURN BOOLEAN IS
3762: BEGIN
3763: SELECT

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

4224: p_stack_err_msg BOOLEAN;
4225: l_location_lookup_type VARCHAR2(30) := 'CSI_INST_LOCATION_SOURCE_CODE';
4226: l_location_source_table VARCHAR2(30);
4227: BEGIN
4228: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
4229: csi_gen_utility_pvt.populate_install_param_rec;
4230: END IF;
4231: --
4232: IF csi_datastructures_pub.g_install_param_rec.fetch_flag = 'N' THEN

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

4228: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
4229: csi_gen_utility_pvt.populate_install_param_rec;
4230: END IF;
4231: --
4232: IF csi_datastructures_pub.g_install_param_rec.fetch_flag = 'N' THEN
4233: FND_MESSAGE.SET_NAME('CSI','CSI_API_UNINSTALLED_PARAMETER');
4234: FND_MSG_PUB.ADD;
4235: l_return_value := FALSE;
4236: RETURN l_return_value;

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

4724: /* associated instances of an instance of */
4725: /* instance item class link */
4726: /*-----------------------------------------------------------*/
4727: PROCEDURE get_link_locations
4728: (p_instance_header_tbl IN OUT NOCOPY csi_datastructures_pub.instance_header_tbl,
4729: x_return_status OUT NOCOPY VARCHAR2
4730: ) IS
4731: l_object_id NUMBER;
4732: l_subject_id NUMBER;

Line 4733: l_header_tbl csi_datastructures_pub.instance_header_tbl ;

4729: x_return_status OUT NOCOPY VARCHAR2
4730: ) IS
4731: l_object_id NUMBER;
4732: l_subject_id NUMBER;
4733: l_header_tbl csi_datastructures_pub.instance_header_tbl ;
4734: l_temp_header_tbl csi_datastructures_pub.instance_header_tbl ;
4735: l_link_type VARCHAR2(30);
4736: i NUMBER;
4737:

Line 4734: l_temp_header_tbl csi_datastructures_pub.instance_header_tbl ;

4730: ) IS
4731: l_object_id NUMBER;
4732: l_subject_id NUMBER;
4733: l_header_tbl csi_datastructures_pub.instance_header_tbl ;
4734: l_temp_header_tbl csi_datastructures_pub.instance_header_tbl ;
4735: l_link_type VARCHAR2(30);
4736: i NUMBER;
4737:
4738: CURSOR link_csr(p_instance_id NUMBER) IS

Line 4842: ( p_instance_rec IN csi_datastructures_pub.instance_rec

4838: END LOOP;
4839: END get_link_locations;
4840:
4841: PROCEDURE Call_batch_validate
4842: ( p_instance_rec IN csi_datastructures_pub.instance_rec
4843: ,p_config_hdr_id IN NUMBER
4844: ,p_config_rev_nbr IN NUMBER
4845: ,x_config_hdr_id OUT NOCOPY NUMBER
4846: ,x_config_rev_nbr OUT NOCOPY NUMBER

Line 4971: ( p_instance_rec IN csi_datastructures_pub.instance_rec

4967: /* will be checked against this list for further processing */
4968: /*-----------------------------------------------------------*/
4969:
4970: PROCEDURE Check_Prior_Txn
4971: ( p_instance_rec IN csi_datastructures_pub.instance_rec
4972: ,p_txn_rec IN csi_datastructures_pub.transaction_rec
4973: ,p_prior_txn_id OUT NOCOPY NUMBER
4974: ,p_mode IN VARCHAR2
4975: ,x_return_status OUT NOCOPY VARCHAR2

Line 4972: ,p_txn_rec IN csi_datastructures_pub.transaction_rec

4968: /*-----------------------------------------------------------*/
4969:
4970: PROCEDURE Check_Prior_Txn
4971: ( p_instance_rec IN csi_datastructures_pub.instance_rec
4972: ,p_txn_rec IN csi_datastructures_pub.transaction_rec
4973: ,p_prior_txn_id OUT NOCOPY NUMBER
4974: ,p_mode IN VARCHAR2
4975: ,x_return_status OUT NOCOPY VARCHAR2
4976: ) AS

Line 5000: l_mtl_txn_tbl csi_datastructures_pub.mtl_txn_tbl;

4996: l_xfer_mtl_txn_id NUMBER;
4997: l_src_txn_date DATE;
4998: l_cur_mtl_txn_id number;
4999: l_cur_mtl_txn_date DATE;
5000: l_mtl_txn_tbl csi_datastructures_pub.mtl_txn_tbl;
5001: l_txn_line_detail_id NUMBER;
5002: l_order_number NUMBER;
5003: l_line_number NUMBER;
5004: l_error_found varchar2(1);

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

5014:
5015: IF p_instance_rec.inventory_item_id is NOT NULL AND p_instance_rec.inventory_item_id <> FND_API.G_MISS_NUM
5016: AND p_instance_rec.serial_number is NOT NULL AND p_instance_rec.serial_number <> FND_API.G_MISS_CHAR
5017: THEN
5018: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
5019: csi_gen_utility_pvt.populate_install_param_rec;
5020: END IF;
5021:
5022: l_txn_seq_start_date := nvl(csi_datastructures_pub.g_install_param_rec.txn_seq_start_date,

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

5018: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
5019: csi_gen_utility_pvt.populate_install_param_rec;
5020: END IF;
5021:
5022: l_txn_seq_start_date := nvl(csi_datastructures_pub.g_install_param_rec.txn_seq_start_date,
5023: csi_datastructures_pub.g_install_param_rec.freeze_date);
5024:
5025: IF l_txn_seq_start_date IS NULL THEN
5026: FND_MESSAGE.SET_NAME('CSI','CSI_API_UNINSTALLED_PARAMETER');

Line 5023: csi_datastructures_pub.g_install_param_rec.freeze_date);

5019: csi_gen_utility_pvt.populate_install_param_rec;
5020: END IF;
5021:
5022: l_txn_seq_start_date := nvl(csi_datastructures_pub.g_install_param_rec.txn_seq_start_date,
5023: csi_datastructures_pub.g_install_param_rec.freeze_date);
5024:
5025: IF l_txn_seq_start_date IS NULL THEN
5026: FND_MESSAGE.SET_NAME('CSI','CSI_API_UNINSTALLED_PARAMETER');
5027: FND_MSG_PUB.ADD;

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

5054: csi_gen_utility_pvt.put_line(' l_cur_mtl_txn_date : '||l_cur_mtl_txn_date);
5055:
5056: IF p_mode = 'CREATE' THEN
5057: decode_queue(p_pending_txn_tbl => l_pending_txn_tbl
5058: ,p_freeze_date => csi_datastructures_pub.g_install_param_rec.freeze_date);
5059: -- For 'UPDATE' mode get the transactions starting from the src txn date used for instance creation.
5060: -- Bug # 4018629
5061: ELSE
5062: l_min_txn_id := NULL;

Line 5356: param_name csi_datastructures_pub.parameter_name;

5352: /*TYPE param_name_type IS TABLE OF VARCHAR2(30)
5353: INDEX BY BINARY_INTEGER;
5354: TYPE param_value_type IS TABLE OF VARCHAR2(200)
5355: INDEX BY BINARY_INTEGER;*/
5356: param_name csi_datastructures_pub.parameter_name;
5357: param_value csi_datastructures_pub.parameter_value;
5358: l_rec_index BINARY_INTEGER;
5359: -- SPC specific params
5360: l_database_id VARCHAR2(100);

Line 5357: param_value csi_datastructures_pub.parameter_value;

5353: INDEX BY BINARY_INTEGER;
5354: TYPE param_value_type IS TABLE OF VARCHAR2(200)
5355: INDEX BY BINARY_INTEGER;*/
5356: param_name csi_datastructures_pub.parameter_name;
5357: param_value csi_datastructures_pub.parameter_value;
5358: l_rec_index BINARY_INTEGER;
5359: -- SPC specific params
5360: l_database_id VARCHAR2(100);
5361: l_save_config_behavior VARCHAR2(30):= 'new_config';

Line 5911: p_instance_rec IN csi_datastructures_pub.instance_rec,

5907: RETURN TRUE;
5908: END pending_in_oi_or_tld;
5909:
5910: PROCEDURE validate_serial_for_upd(
5911: p_instance_rec IN csi_datastructures_pub.instance_rec,
5912: p_txn_rec IN csi_datastructures_pub.transaction_rec,
5913: p_old_serial_number IN varchar2,
5914: x_return_status OUT nocopy varchar2)
5915: IS

Line 5912: p_txn_rec IN csi_datastructures_pub.transaction_rec,

5908: END pending_in_oi_or_tld;
5909:
5910: PROCEDURE validate_serial_for_upd(
5911: p_instance_rec IN csi_datastructures_pub.instance_rec,
5912: p_txn_rec IN csi_datastructures_pub.transaction_rec,
5913: p_old_serial_number IN varchar2,
5914: x_return_status OUT nocopy varchar2)
5915: IS
5916:

Line 6137: x_mtl_txn_tbl OUT nocopy csi_datastructures_pub.mtl_txn_tbl)

6133:
6134: PROCEDURE get_mtl_txn_for_srl(
6135: p_inventory_item_id IN number,
6136: p_serial_number IN varchar2,
6137: x_mtl_txn_tbl OUT nocopy csi_datastructures_pub.mtl_txn_tbl)
6138: IS
6139:
6140: l_mtl_txn_id number;
6141: l_lot_number varchar2(30);

Line 6142: l_mtl_txn_tbl csi_datastructures_pub.mtl_txn_tbl;

6138: IS
6139:
6140: l_mtl_txn_id number;
6141: l_lot_number varchar2(30);
6142: l_mtl_txn_tbl csi_datastructures_pub.mtl_txn_tbl;
6143: l_ind binary_integer := 0;
6144: x_ind binary_integer := 0;
6145: l_txn_seq_start_date date;
6146:

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

6161: ORDER BY mut.creation_date desc, mut.transaction_id desc;
6162:
6163: BEGIN
6164:
6165: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
6166: csi_gen_utility_pvt.populate_install_param_rec;
6167: END IF;
6168:
6169: l_txn_seq_start_date := csi_datastructures_pub.g_install_param_rec.txn_seq_start_date;

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

6165: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
6166: csi_gen_utility_pvt.populate_install_param_rec;
6167: END IF;
6168:
6169: l_txn_seq_start_date := csi_datastructures_pub.g_install_param_rec.txn_seq_start_date;
6170: IF l_txn_seq_start_date is null THEN
6171: l_txn_seq_start_date := csi_datastructures_pub.g_install_param_rec.freeze_date;
6172: END IF;
6173:

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

6167: END IF;
6168:
6169: l_txn_seq_start_date := csi_datastructures_pub.g_install_param_rec.txn_seq_start_date;
6170: IF l_txn_seq_start_date is null THEN
6171: l_txn_seq_start_date := csi_datastructures_pub.g_install_param_rec.freeze_date;
6172: END IF;
6173:
6174: IF l_txn_seq_start_date is null THEN
6175: fnd_message.set_name('CSI','CSI_API_UNINSTALLED_PARAMETER');