676: set status_code = 'IP'
677: where batch_id = l_batch_rec.batch_id;
678:
679: -- assign attribute values to global_variables
680: fa_cua_asset_apis.g_process_batch := 'Y';
681: fa_cua_asset_apis.g_transaction_name := l_batch_rec.transaction_name;
682: fa_cua_asset_apis.g_attribute_category := l_batch_rec.attribute_category;
683: fa_cua_asset_apis.g_attribute1 := l_batch_rec.attribute1;
684: fa_cua_asset_apis.g_attribute2 := l_batch_rec.attribute2;
677: where batch_id = l_batch_rec.batch_id;
678:
679: -- assign attribute values to global_variables
680: fa_cua_asset_apis.g_process_batch := 'Y';
681: fa_cua_asset_apis.g_transaction_name := l_batch_rec.transaction_name;
682: fa_cua_asset_apis.g_attribute_category := l_batch_rec.attribute_category;
683: fa_cua_asset_apis.g_attribute1 := l_batch_rec.attribute1;
684: fa_cua_asset_apis.g_attribute2 := l_batch_rec.attribute2;
685: fa_cua_asset_apis.g_attribute3 := l_batch_rec.attribute3;
678:
679: -- assign attribute values to global_variables
680: fa_cua_asset_apis.g_process_batch := 'Y';
681: fa_cua_asset_apis.g_transaction_name := l_batch_rec.transaction_name;
682: fa_cua_asset_apis.g_attribute_category := l_batch_rec.attribute_category;
683: fa_cua_asset_apis.g_attribute1 := l_batch_rec.attribute1;
684: fa_cua_asset_apis.g_attribute2 := l_batch_rec.attribute2;
685: fa_cua_asset_apis.g_attribute3 := l_batch_rec.attribute3;
686: fa_cua_asset_apis.g_attribute4 := l_batch_rec.attribute4;
679: -- assign attribute values to global_variables
680: fa_cua_asset_apis.g_process_batch := 'Y';
681: fa_cua_asset_apis.g_transaction_name := l_batch_rec.transaction_name;
682: fa_cua_asset_apis.g_attribute_category := l_batch_rec.attribute_category;
683: fa_cua_asset_apis.g_attribute1 := l_batch_rec.attribute1;
684: fa_cua_asset_apis.g_attribute2 := l_batch_rec.attribute2;
685: fa_cua_asset_apis.g_attribute3 := l_batch_rec.attribute3;
686: fa_cua_asset_apis.g_attribute4 := l_batch_rec.attribute4;
687: fa_cua_asset_apis.g_attribute5 := l_batch_rec.attribute5;
680: fa_cua_asset_apis.g_process_batch := 'Y';
681: fa_cua_asset_apis.g_transaction_name := l_batch_rec.transaction_name;
682: fa_cua_asset_apis.g_attribute_category := l_batch_rec.attribute_category;
683: fa_cua_asset_apis.g_attribute1 := l_batch_rec.attribute1;
684: fa_cua_asset_apis.g_attribute2 := l_batch_rec.attribute2;
685: fa_cua_asset_apis.g_attribute3 := l_batch_rec.attribute3;
686: fa_cua_asset_apis.g_attribute4 := l_batch_rec.attribute4;
687: fa_cua_asset_apis.g_attribute5 := l_batch_rec.attribute5;
688: fa_cua_asset_apis.g_attribute6 := l_batch_rec.attribute6;
681: fa_cua_asset_apis.g_transaction_name := l_batch_rec.transaction_name;
682: fa_cua_asset_apis.g_attribute_category := l_batch_rec.attribute_category;
683: fa_cua_asset_apis.g_attribute1 := l_batch_rec.attribute1;
684: fa_cua_asset_apis.g_attribute2 := l_batch_rec.attribute2;
685: fa_cua_asset_apis.g_attribute3 := l_batch_rec.attribute3;
686: fa_cua_asset_apis.g_attribute4 := l_batch_rec.attribute4;
687: fa_cua_asset_apis.g_attribute5 := l_batch_rec.attribute5;
688: fa_cua_asset_apis.g_attribute6 := l_batch_rec.attribute6;
689: fa_cua_asset_apis.g_attribute7 := l_batch_rec.attribute7;
682: fa_cua_asset_apis.g_attribute_category := l_batch_rec.attribute_category;
683: fa_cua_asset_apis.g_attribute1 := l_batch_rec.attribute1;
684: fa_cua_asset_apis.g_attribute2 := l_batch_rec.attribute2;
685: fa_cua_asset_apis.g_attribute3 := l_batch_rec.attribute3;
686: fa_cua_asset_apis.g_attribute4 := l_batch_rec.attribute4;
687: fa_cua_asset_apis.g_attribute5 := l_batch_rec.attribute5;
688: fa_cua_asset_apis.g_attribute6 := l_batch_rec.attribute6;
689: fa_cua_asset_apis.g_attribute7 := l_batch_rec.attribute7;
690: fa_cua_asset_apis.g_attribute8 := l_batch_rec.attribute8;
683: fa_cua_asset_apis.g_attribute1 := l_batch_rec.attribute1;
684: fa_cua_asset_apis.g_attribute2 := l_batch_rec.attribute2;
685: fa_cua_asset_apis.g_attribute3 := l_batch_rec.attribute3;
686: fa_cua_asset_apis.g_attribute4 := l_batch_rec.attribute4;
687: fa_cua_asset_apis.g_attribute5 := l_batch_rec.attribute5;
688: fa_cua_asset_apis.g_attribute6 := l_batch_rec.attribute6;
689: fa_cua_asset_apis.g_attribute7 := l_batch_rec.attribute7;
690: fa_cua_asset_apis.g_attribute8 := l_batch_rec.attribute8;
691: fa_cua_asset_apis.g_attribute9 := l_batch_rec.attribute9;
684: fa_cua_asset_apis.g_attribute2 := l_batch_rec.attribute2;
685: fa_cua_asset_apis.g_attribute3 := l_batch_rec.attribute3;
686: fa_cua_asset_apis.g_attribute4 := l_batch_rec.attribute4;
687: fa_cua_asset_apis.g_attribute5 := l_batch_rec.attribute5;
688: fa_cua_asset_apis.g_attribute6 := l_batch_rec.attribute6;
689: fa_cua_asset_apis.g_attribute7 := l_batch_rec.attribute7;
690: fa_cua_asset_apis.g_attribute8 := l_batch_rec.attribute8;
691: fa_cua_asset_apis.g_attribute9 := l_batch_rec.attribute9;
692: fa_cua_asset_apis.g_attribute10 := l_batch_rec.attribute10;
685: fa_cua_asset_apis.g_attribute3 := l_batch_rec.attribute3;
686: fa_cua_asset_apis.g_attribute4 := l_batch_rec.attribute4;
687: fa_cua_asset_apis.g_attribute5 := l_batch_rec.attribute5;
688: fa_cua_asset_apis.g_attribute6 := l_batch_rec.attribute6;
689: fa_cua_asset_apis.g_attribute7 := l_batch_rec.attribute7;
690: fa_cua_asset_apis.g_attribute8 := l_batch_rec.attribute8;
691: fa_cua_asset_apis.g_attribute9 := l_batch_rec.attribute9;
692: fa_cua_asset_apis.g_attribute10 := l_batch_rec.attribute10;
693: fa_cua_asset_apis.g_attribute11 := l_batch_rec.attribute11;
686: fa_cua_asset_apis.g_attribute4 := l_batch_rec.attribute4;
687: fa_cua_asset_apis.g_attribute5 := l_batch_rec.attribute5;
688: fa_cua_asset_apis.g_attribute6 := l_batch_rec.attribute6;
689: fa_cua_asset_apis.g_attribute7 := l_batch_rec.attribute7;
690: fa_cua_asset_apis.g_attribute8 := l_batch_rec.attribute8;
691: fa_cua_asset_apis.g_attribute9 := l_batch_rec.attribute9;
692: fa_cua_asset_apis.g_attribute10 := l_batch_rec.attribute10;
693: fa_cua_asset_apis.g_attribute11 := l_batch_rec.attribute11;
694: fa_cua_asset_apis.g_attribute12 := l_batch_rec.attribute12;
687: fa_cua_asset_apis.g_attribute5 := l_batch_rec.attribute5;
688: fa_cua_asset_apis.g_attribute6 := l_batch_rec.attribute6;
689: fa_cua_asset_apis.g_attribute7 := l_batch_rec.attribute7;
690: fa_cua_asset_apis.g_attribute8 := l_batch_rec.attribute8;
691: fa_cua_asset_apis.g_attribute9 := l_batch_rec.attribute9;
692: fa_cua_asset_apis.g_attribute10 := l_batch_rec.attribute10;
693: fa_cua_asset_apis.g_attribute11 := l_batch_rec.attribute11;
694: fa_cua_asset_apis.g_attribute12 := l_batch_rec.attribute12;
695: fa_cua_asset_apis.g_attribute13 := l_batch_rec.attribute13;
688: fa_cua_asset_apis.g_attribute6 := l_batch_rec.attribute6;
689: fa_cua_asset_apis.g_attribute7 := l_batch_rec.attribute7;
690: fa_cua_asset_apis.g_attribute8 := l_batch_rec.attribute8;
691: fa_cua_asset_apis.g_attribute9 := l_batch_rec.attribute9;
692: fa_cua_asset_apis.g_attribute10 := l_batch_rec.attribute10;
693: fa_cua_asset_apis.g_attribute11 := l_batch_rec.attribute11;
694: fa_cua_asset_apis.g_attribute12 := l_batch_rec.attribute12;
695: fa_cua_asset_apis.g_attribute13 := l_batch_rec.attribute13;
696: fa_cua_asset_apis.g_attribute14 := l_batch_rec.attribute14;
689: fa_cua_asset_apis.g_attribute7 := l_batch_rec.attribute7;
690: fa_cua_asset_apis.g_attribute8 := l_batch_rec.attribute8;
691: fa_cua_asset_apis.g_attribute9 := l_batch_rec.attribute9;
692: fa_cua_asset_apis.g_attribute10 := l_batch_rec.attribute10;
693: fa_cua_asset_apis.g_attribute11 := l_batch_rec.attribute11;
694: fa_cua_asset_apis.g_attribute12 := l_batch_rec.attribute12;
695: fa_cua_asset_apis.g_attribute13 := l_batch_rec.attribute13;
696: fa_cua_asset_apis.g_attribute14 := l_batch_rec.attribute14;
697: fa_cua_asset_apis.g_attribute15 := l_batch_rec.attribute15;
690: fa_cua_asset_apis.g_attribute8 := l_batch_rec.attribute8;
691: fa_cua_asset_apis.g_attribute9 := l_batch_rec.attribute9;
692: fa_cua_asset_apis.g_attribute10 := l_batch_rec.attribute10;
693: fa_cua_asset_apis.g_attribute11 := l_batch_rec.attribute11;
694: fa_cua_asset_apis.g_attribute12 := l_batch_rec.attribute12;
695: fa_cua_asset_apis.g_attribute13 := l_batch_rec.attribute13;
696: fa_cua_asset_apis.g_attribute14 := l_batch_rec.attribute14;
697: fa_cua_asset_apis.g_attribute15 := l_batch_rec.attribute15;
698:
691: fa_cua_asset_apis.g_attribute9 := l_batch_rec.attribute9;
692: fa_cua_asset_apis.g_attribute10 := l_batch_rec.attribute10;
693: fa_cua_asset_apis.g_attribute11 := l_batch_rec.attribute11;
694: fa_cua_asset_apis.g_attribute12 := l_batch_rec.attribute12;
695: fa_cua_asset_apis.g_attribute13 := l_batch_rec.attribute13;
696: fa_cua_asset_apis.g_attribute14 := l_batch_rec.attribute14;
697: fa_cua_asset_apis.g_attribute15 := l_batch_rec.attribute15;
698:
699: l_trans_rec.transaction_name := l_batch_rec.transaction_name;
692: fa_cua_asset_apis.g_attribute10 := l_batch_rec.attribute10;
693: fa_cua_asset_apis.g_attribute11 := l_batch_rec.attribute11;
694: fa_cua_asset_apis.g_attribute12 := l_batch_rec.attribute12;
695: fa_cua_asset_apis.g_attribute13 := l_batch_rec.attribute13;
696: fa_cua_asset_apis.g_attribute14 := l_batch_rec.attribute14;
697: fa_cua_asset_apis.g_attribute15 := l_batch_rec.attribute15;
698:
699: l_trans_rec.transaction_name := l_batch_rec.transaction_name;
700: l_trans_rec.desc_flex.attribute_category_code := l_batch_rec.attribute_category;
693: fa_cua_asset_apis.g_attribute11 := l_batch_rec.attribute11;
694: fa_cua_asset_apis.g_attribute12 := l_batch_rec.attribute12;
695: fa_cua_asset_apis.g_attribute13 := l_batch_rec.attribute13;
696: fa_cua_asset_apis.g_attribute14 := l_batch_rec.attribute14;
697: fa_cua_asset_apis.g_attribute15 := l_batch_rec.attribute15;
698:
699: l_trans_rec.transaction_name := l_batch_rec.transaction_name;
700: l_trans_rec.desc_flex.attribute_category_code := l_batch_rec.attribute_category;
701: l_trans_rec.desc_flex.attribute1 := l_batch_rec.attribute1;
1070:
1071: FOR l_get_lines_rec in l_get_lines_csr LOOP
1072:
1073: -- cleanup for each loop
1074: fa_cua_asset_apis.g_derive_from_entity := null;
1075: fa_cua_asset_apis.g_derive_from_entity_value := null;
1076: l_update_attribute := 'N';
1077:
1078: if l_get_lines_rec.attribute_name = 'CATEGORY' then
1071: FOR l_get_lines_rec in l_get_lines_csr LOOP
1072:
1073: -- cleanup for each loop
1074: fa_cua_asset_apis.g_derive_from_entity := null;
1075: fa_cua_asset_apis.g_derive_from_entity_value := null;
1076: l_update_attribute := 'N';
1077:
1078: if l_get_lines_rec.attribute_name = 'CATEGORY' then
1079: if (l_get_lines_rec.attribute_old_id <> l_get_lines_rec.attribute_new_id)
1180: -- assign Life Derivation info to global variables. The global variables
1181: -- are refernced from DB trigger on FA_TRANSACTION_HEADERS to populate
1182: -- FA_LIFE_DERIVATION_INFO;
1183:
1184: fa_cua_asset_apis.g_derive_from_entity := l_get_lines_rec.derived_from_entity;
1185: fa_cua_asset_apis.g_derive_from_entity_value := l_get_lines_rec.derived_from_entity_id;
1186:
1187: do_adjustment ( px_trans_rec => px_trans_rec,
1188: px_asset_hdr_rec => l_asset_hdr_rec,
1181: -- are refernced from DB trigger on FA_TRANSACTION_HEADERS to populate
1182: -- FA_LIFE_DERIVATION_INFO;
1183:
1184: fa_cua_asset_apis.g_derive_from_entity := l_get_lines_rec.derived_from_entity;
1185: fa_cua_asset_apis.g_derive_from_entity_value := l_get_lines_rec.derived_from_entity_id;
1186:
1187: do_adjustment ( px_trans_rec => px_trans_rec,
1188: px_asset_hdr_rec => l_asset_hdr_rec,
1189: x_new_life => l_new_life,