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