DBA Data[Home] [Help]

APPS.FA_CUA_MASS_UPDATE1_PKG dependencies on FA_CUA_ASSET_APIS

Line 680: fa_cua_asset_apis.g_process_batch := 'Y';

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;

Line 681: fa_cua_asset_apis.g_transaction_name := l_batch_rec.transaction_name;

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;

Line 682: fa_cua_asset_apis.g_attribute_category := l_batch_rec.attribute_category;

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;

Line 683: fa_cua_asset_apis.g_attribute1 := l_batch_rec.attribute1;

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;

Line 684: fa_cua_asset_apis.g_attribute2 := l_batch_rec.attribute2;

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;

Line 685: fa_cua_asset_apis.g_attribute3 := l_batch_rec.attribute3;

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;

Line 686: fa_cua_asset_apis.g_attribute4 := l_batch_rec.attribute4;

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;

Line 687: fa_cua_asset_apis.g_attribute5 := l_batch_rec.attribute5;

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;

Line 688: fa_cua_asset_apis.g_attribute6 := l_batch_rec.attribute6;

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;

Line 689: fa_cua_asset_apis.g_attribute7 := l_batch_rec.attribute7;

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;

Line 690: fa_cua_asset_apis.g_attribute8 := l_batch_rec.attribute8;

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;

Line 691: fa_cua_asset_apis.g_attribute9 := l_batch_rec.attribute9;

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;

Line 692: fa_cua_asset_apis.g_attribute10 := l_batch_rec.attribute10;

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;

Line 693: fa_cua_asset_apis.g_attribute11 := l_batch_rec.attribute11;

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;

Line 694: fa_cua_asset_apis.g_attribute12 := l_batch_rec.attribute12;

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:

Line 695: fa_cua_asset_apis.g_attribute13 := l_batch_rec.attribute13;

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;

Line 696: fa_cua_asset_apis.g_attribute14 := l_batch_rec.attribute14;

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;

Line 697: fa_cua_asset_apis.g_attribute15 := l_batch_rec.attribute15;

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;

Line 1074: fa_cua_asset_apis.g_derive_from_entity := null;

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

Line 1075: fa_cua_asset_apis.g_derive_from_entity_value := null;

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)

Line 1184: fa_cua_asset_apis.g_derive_from_entity := l_get_lines_rec.derived_from_entity;

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,

Line 1185: fa_cua_asset_apis.g_derive_from_entity_value := l_get_lines_rec.derived_from_entity_id;

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,