DBA Data[Home] [Help]

APPS.IEU_WR_PUB dependencies on FND_PROFILE

Line 104: l_audit_log_val := FND_PROFILE.VALUE('IEU_WR_DIST_AUDIT_LOG');

100:
101:
102: BEGIN
103:
104: l_audit_log_val := FND_PROFILE.VALUE('IEU_WR_DIST_AUDIT_LOG');
105: l_token_str := '';
106: SAVEPOINT insert_wr_items_sp;
107:
108: x_return_status := fnd_api.g_ret_sts_success;

Line 981: l_audit_log_val := FND_PROFILE.VALUE('IEU_WR_DIST_AUDIT_LOG');

977: l_reschedule_time DATE;
978:
979: BEGIN
980:
981: l_audit_log_val := FND_PROFILE.VALUE('IEU_WR_DIST_AUDIT_LOG');
982: l_api_name := 'UPDATE_WR_ITEM';
983: l_token_str := '';
984: SAVEPOINT update_wr_items_sp;
985: x_return_status := fnd_api.g_ret_sts_success;

Line 2029: l_audit_log_val := FND_PROFILE.VALUE('IEU_WR_DIST_AUDIT_LOG');

2025: errors number;
2026:
2027: BEGIN
2028:
2029: l_audit_log_val := FND_PROFILE.VALUE('IEU_WR_DIST_AUDIT_LOG');
2030: l_token_str := '';
2031: l_dist_from := 'GROUP_OWNED';
2032: l_dist_to := 'INDIVIDUAL_ASSIGNED';
2033: l_priority_code := 'LOW';

Line 2658: l_audit_log_val := FND_PROFILE.VALUE('IEU_WR_DIST_AUDIT_LOG');

2654: l_bindvar_to_list IEU_UWQ_GET_NEXT_WORK_PVT.IEU_UWQ_BINDVAR_LIST;
2655:
2656: BEGIN
2657:
2658: l_audit_log_val := FND_PROFILE.VALUE('IEU_WR_DIST_AUDIT_LOG');
2659: l_token_str := '';
2660: l_dist_from := 'GROUP_OWNED';
2661: l_dist_to := 'INDIVIDUAL_ASSIGNED';
2662: SAVEPOINT next_work_for_apps;

Line 2830: l_audit_log_val := FND_PROFILE.VALUE('IEU_WR_DIST_AUDIT_LOG');

2826: l_parent_status_id NUMBER;
2827:
2828: BEGIN
2829:
2830: l_audit_log_val := FND_PROFILE.VALUE('IEU_WR_DIST_AUDIT_LOG');
2831: l_token_str := '';
2832: l_dist_from := 'GROUP_OWNED';
2833: l_dist_to := 'INDIVIDUAL_ASSIGNED';
2834: SAVEPOINT sync_dependent_wr_items_sp;

Line 3142: -- l_audit_log_val := FND_PROFILE.VALUE('IEU_WR_DIST_AUDIT_LOG');

3138:
3139: /******** overloaded Proc for Audit Log ***************/
3140:
3141: -- Get the Audit Log profile Option
3142: -- l_audit_log_val := FND_PROFILE.VALUE('IEU_WR_DIST_AUDIT_LOG');
3143:
3144:
3145: PROCEDURE CREATE_WR_ITEM
3146: ( p_api_version IN NUMBER,

Line 3263: l_audit_log_val := FND_PROFILE.VALUE('IEU_WR_DIST_AUDIT_LOG');

3259: BEGIN
3260:
3261: l_token_str := '';
3262: SAVEPOINT insert_wr_items_sp;
3263: l_audit_log_val := FND_PROFILE.VALUE('IEU_WR_DIST_AUDIT_LOG');
3264:
3265: x_return_status := fnd_api.g_ret_sts_success;
3266:
3267: -- Check for API Version

Line 4579: l_audit_log_val := FND_PROFILE.VALUE('IEU_WR_DIST_AUDIT_LOG');

4575: l_audit_log_id NUMBER;
4576:
4577: BEGIN
4578:
4579: l_audit_log_val := FND_PROFILE.VALUE('IEU_WR_DIST_AUDIT_LOG');
4580: l_api_name := 'UPDATE_WR_ITEM';
4581: l_token_str := '';
4582: SAVEPOINT update_wr_items_sp;
4583: x_return_status := fnd_api.g_ret_sts_success;

Line 6121: l_audit_log_val := FND_PROFILE.VALUE('IEU_WR_DIST_AUDIT_LOG');

6117: l_workitem_pk_id NUMBER;
6118:
6119: BEGIN
6120:
6121: l_audit_log_val := FND_PROFILE.VALUE('IEU_WR_DIST_AUDIT_LOG');
6122: l_token_str := '';
6123:
6124: SAVEPOINT reschedule_uwqm_items_sp;
6125: x_return_status := fnd_api.g_ret_sts_success;

Line 6866: l_audit_log_val := FND_PROFILE.VALUE('IEU_WR_DIST_AUDIT_LOG');

6862: errors number;
6863:
6864: BEGIN
6865:
6866: l_audit_log_val := FND_PROFILE.VALUE('IEU_WR_DIST_AUDIT_LOG');
6867: l_priority_code := 'LOW';
6868: l_token_str := '';
6869: l_dist_from := 'GROUP_OWNED';
6870: l_dist_to := 'INDIVIDUAL_ASSIGNED';

Line 7896: l_audit_log_val := FND_PROFILE.VALUE('IEU_WR_DIST_AUDIT_LOG');

7892:
7893:
7894: BEGIN
7895:
7896: l_audit_log_val := FND_PROFILE.VALUE('IEU_WR_DIST_AUDIT_LOG');
7897: l_token_str := '';
7898: l_dist_from := 'GROUP_OWNED';
7899: l_dist_to := 'INDIVIDUAL_ASSIGNED';
7900: SAVEPOINT next_work_for_apps;

Line 8473: l_audit_log_val := FND_PROFILE.VALUE('IEU_WR_DIST_AUDIT_LOG');

8469: l_audit_log_id NUMBER;
8470:
8471: BEGIN
8472:
8473: l_audit_log_val := FND_PROFILE.VALUE('IEU_WR_DIST_AUDIT_LOG');
8474: l_token_str := '';
8475: l_dist_from := 'GROUP_OWNED';
8476: l_dist_to := 'INDIVIDUAL_ASSIGNED';
8477: SAVEPOINT sync_dependent_wr_items_sp;

Line 9201: l_audit_log_val := FND_PROFILE.VALUE('IEU_WR_DIST_AUDIT_LOG');

9197:
9198: l_ws_code VARCHAR2(32);
9199: BEGIN
9200:
9201: l_audit_log_val := FND_PROFILE.VALUE('IEU_WR_DIST_AUDIT_LOG');
9202: l_token_str := '';
9203: SAVEPOINT activate_ws_sp;
9204: x_return_status := fnd_api.g_ret_sts_success;
9205:

Line 9359: l_audit_log_val := FND_PROFILE.VALUE('IEU_WR_DIST_AUDIT_LOG');

9355: l_ws_activation_status VARCHAR2(1);
9356:
9357: BEGIN
9358:
9359: l_audit_log_val := FND_PROFILE.VALUE('IEU_WR_DIST_AUDIT_LOG');
9360: l_token_str := '';
9361: SAVEPOINT check_ws_activation_status_sp;
9362: x_return_status := fnd_api.g_ret_sts_success;
9363:

Line 9776: l_audit_log_val := FND_PROFILE.VALUE('IEU_WR_DIST_AUDIT_LOG');

9772: l_msg_data2 varchar2(4000);
9773:
9774: BEGIN
9775:
9776: l_audit_log_val := FND_PROFILE.VALUE('IEU_WR_DIST_AUDIT_LOG');
9777: l_api_name := 'PURGE_WR_ITEM';
9778: l_token_str := '';
9779: SAVEPOINT purge_wr_items_sp;
9780: x_return_status := fnd_api.g_ret_sts_success;

Line 10317: l_audit_log_val := FND_PROFILE.VALUE('IEU_WR_DIST_AUDIT_LOG');

10313: and p.parent_ws_id = l_ws_id;
10314:
10315: BEGIN
10316:
10317: l_audit_log_val := FND_PROFILE.VALUE('IEU_WR_DIST_AUDIT_LOG');
10318: l_token_str := '';
10319: SAVEPOINT deactivate_ws_sp;
10320: x_return_status := fnd_api.g_ret_sts_success;
10321:

Line 10532: l_audit_log_val := FND_PROFILE.VALUE('IEU_WR_DIST_AUDIT_LOG');

10528: errors number;
10529: err_flag varchar2(1);
10530:
10531: BEGIN
10532: l_audit_log_val := FND_PROFILE.VALUE('IEU_WR_DIST_AUDIT_LOG');
10533: l_token_str := '';
10534: l_not_valid_flag := 'N';
10535: errors := 0;
10536: err_flag := 'N';

Line 11415: l_audit_log_val := FND_PROFILE.VALUE('IEU_WR_DIST_AUDIT_LOG');

11411: l_done BOOLEAN;
11412:
11413: BEGIN
11414: l_error_count := 0;
11415: l_audit_log_val := FND_PROFILE.VALUE('IEU_WR_DIST_AUDIT_LOG');
11416: l_token_str := '';
11417: l_limit := 2000;
11418:
11419: SAVEPOINT sync_assct_task_wr_items_sp;

Line 12077: l_audit_log_val := FND_PROFILE.VALUE('IEU_WR_DIST_AUDIT_LOG');

12073: l_msg_data VARCHAR2(4000);
12074: l_return_status VARCHAR2(1);
12075:
12076: BEGIN
12077: l_audit_log_val := FND_PROFILE.VALUE('IEU_WR_DIST_AUDIT_LOG');
12078:
12079: errors := 0;
12080: l_return_status := FND_API.G_RET_STS_SUCCESS;
12081:

Line 12372: l_audit_log_val := FND_PROFILE.VALUE('IEU_WR_DIST_AUDIT_LOG');

12368: l_obj_code VARCHAR2(500);
12369: l_not_valid_flag VARCHAR2(1);
12370:
12371: BEGIN
12372: l_audit_log_val := FND_PROFILE.VALUE('IEU_WR_DIST_AUDIT_LOG');
12373: l_token_str := '';
12374: l_not_valid_flag := 'N';
12375: L_MISS_NUM := FND_API.G_MISS_NUM;
12376:

Line 12849: l_audit_log_val := FND_PROFILE.VALUE('IEU_WR_DIST_AUDIT_LOG');

12845: and status_id = 0;
12846:
12847: BEGIN
12848:
12849: l_audit_log_val := FND_PROFILE.VALUE('IEU_WR_DIST_AUDIT_LOG');
12850: l_token_str := '';
12851: l_not_valid_flag := 'N';
12852: l_array_size := 2000;
12853: