APPS.IGS_DA_TRNS_IMP dependencies on STANDARD

Line 915: WHERE CLASS = 'UNIT_DIFFICULTY' AND NAME = 'STANDARD';

911: CURSOR c_unit_difficulty
912: IS
913: SELECT code_id
914: FROM igs_ad_code_classes
915: WHERE CLASS = 'UNIT_DIFFICULTY' AND NAME = 'STANDARD';
916:
917: l_rowid VARCHAR2 (25);
918: l_var VARCHAR2 (25);
919: l_unit_details_id igs_ad_term_unitdtls.unit_details_id%TYPE;

Line 2837: --Standard start of API savepoint

2833: RETURN;
2834: END IF;
2835:
2836: write_message ('ENTERED create_adv_stnd_unit ');
2837: --Standard start of API savepoint
2838: SAVEPOINT create_adv_stnd_unit;
2839: fnd_msg_pub.initialize;
2840: --Initialize API return status to success.
2841: l_return_status := fnd_api.g_ret_sts_success;

Line 3235: --Standard call to get message count and if count is 1, get message info.

3231: -- COMMIT;
3232: write_message ('************************ END ADVSTND ********************'
3233: );
3234: ecx_debug.pop ('IGS_DA_TRNS_IMP.CREATE_ADV_STND_UNIT');
3235: --Standard call to get message count and if count is 1, get message info.
3236: fnd_msg_pub.count_and_get (p_count => l_msg_count,
3237: p_data => l_msg_data);
3238: EXCEPTION
3239: WHEN duplicate_record_exists