eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.ZPB_DC_OBJECTS_PVT dependencies on FND_GLOBAL

Line 177: fnd_global.LOGIN_ID,

173: p_object_id,
174: p_distributor_user_id,
175: SYSDATE,
176: p_approver_type,
177: fnd_global.LOGIN_ID,
178: fnd_global.user_id,
179: SYSDATE,
180: fnd_global.user_id,
181: SYSDATE

Line 178: fnd_global.user_id,

174: p_distributor_user_id,
175: SYSDATE,
176: p_approver_type,
177: fnd_global.LOGIN_ID,
178: fnd_global.user_id,
179: SYSDATE,
180: fnd_global.user_id,
181: SYSDATE
182: );

Line 180: fnd_global.user_id,

176: p_approver_type,
177: fnd_global.LOGIN_ID,
178: fnd_global.user_id,
179: SYSDATE,
180: fnd_global.user_id,
181: SYSDATE
182: );
183: END Populate_Distributors;
184:

Line 248: fnd_global.user_id,

244: VALUES
245: (p_object_id,
246: p_approver_user_id,
247: p_approval_date,
248: fnd_global.user_id,
249: SYSDATE,
250: fnd_global.LOGIN_ID,
251: fnd_global.user_id,
252: SYSDATE);

Line 250: fnd_global.LOGIN_ID,

246: p_approver_user_id,
247: p_approval_date,
248: fnd_global.user_id,
249: SYSDATE,
250: fnd_global.LOGIN_ID,
251: fnd_global.user_id,
252: SYSDATE);
253:
254: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 251: fnd_global.user_id,

247: p_approval_date,
248: fnd_global.user_id,
249: SYSDATE,
250: fnd_global.LOGIN_ID,
251: fnd_global.user_id,
252: SYSDATE);
253:
254: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
255: p_data => x_msg_data );

Line 345: LAST_UPDATED_BY = fnd_global.user_id,

341: APPROVER_TYPE = 'DISTRIBUTOR',
342: DESCRIPTION = l_dist_template_row_rec.description,
343: -- WHO columns
344: LAST_UPDATE_DATE = SYSDATE,
345: LAST_UPDATED_BY = fnd_global.user_id,
346: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
347: WHERE TEMPLATE_ID = p_template_id
348: AND OBJECT_TYPE in ('W','C');
349: END IF;

Line 346: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID

342: DESCRIPTION = l_dist_template_row_rec.description,
343: -- WHO columns
344: LAST_UPDATE_DATE = SYSDATE,
345: LAST_UPDATED_BY = fnd_global.user_id,
346: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
347: WHERE TEMPLATE_ID = p_template_id
348: AND OBJECT_TYPE in ('W','C');
349: END IF;
350: END LOOP;

Line 441: LAST_UPDATED_BY = fnd_global.USER_ID,

437: APPROVER_TYPE = p_approver_type,
438: ENABLE_TARGET_FLAG = p_enable_target_flag,
439: CREATE_INSTANCE_MEASURES_FLAG = p_create_inst_mea_flag,
440: MULTIPLE_SUBMISSIONS_FLAG = p_multiple_submissions_flag,
441: LAST_UPDATED_BY = fnd_global.USER_ID,
442: LAST_UPDATE_DATE = SYSDATE,
443: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
444: WHERE TEMPLATE_ID = p_template_id
445: AND OBJECT_TYPE = 'M';

Line 443: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID

439: CREATE_INSTANCE_MEASURES_FLAG = p_create_inst_mea_flag,
440: MULTIPLE_SUBMISSIONS_FLAG = p_multiple_submissions_flag,
441: LAST_UPDATED_BY = fnd_global.USER_ID,
442: LAST_UPDATE_DATE = SYSDATE,
443: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
444: WHERE TEMPLATE_ID = p_template_id
445: AND OBJECT_TYPE = 'M';
446: END IF;
447:

Line 453: LAST_UPDATED_BY = fnd_global.USER_ID,

449: -- Ater the distribution, the status of templates changes --
450: UPDATE ZPB_DC_OBJECTS
451: SET STATUS = 'DISTRIBUTED',
452: DISTRIBUTION_DATE = SYSDATE,
453: LAST_UPDATED_BY = fnd_global.USER_ID,
454: LAST_UPDATE_DATE = SYSDATE,
455: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
456: WHERE TEMPLATE_ID = p_template_id
457: AND OBJECT_TYPE in ('M','E');

Line 455: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID

451: SET STATUS = 'DISTRIBUTED',
452: DISTRIBUTION_DATE = SYSDATE,
453: LAST_UPDATED_BY = fnd_global.USER_ID,
454: LAST_UPDATE_DATE = SYSDATE,
455: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
456: WHERE TEMPLATE_ID = p_template_id
457: AND OBJECT_TYPE in ('M','E');
458: END IF;
459:

Line 565: fnd_global.user_id ,

561: 'N',
562: 'Y',
563: 'Y',
564: SYSDATE ,
565: fnd_global.user_id ,
566: fnd_global.LOGIN_ID,
567: SYSDATE ,
568: fnd_global.user_id,
569: p_currency_flag,

Line 566: fnd_global.LOGIN_ID,

562: 'Y',
563: 'Y',
564: SYSDATE ,
565: fnd_global.user_id ,
566: fnd_global.LOGIN_ID,
567: SYSDATE ,
568: fnd_global.user_id,
569: p_currency_flag,
570: p_view_type,

Line 568: fnd_global.user_id,

564: SYSDATE ,
565: fnd_global.user_id ,
566: fnd_global.LOGIN_ID,
567: SYSDATE ,
568: fnd_global.user_id,
569: p_currency_flag,
570: p_view_type,
571: p_business_area_id,
572: p_multiple_submissions_flag);

Line 578: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID,

574: -- Update distributors table
575: UPDATE ZPB_DC_DISTRIBUTORS
576: SET DISTRIBUTION_DATE = SYSDATE,
577: APPROVER_TYPE = l_approver_type,
578: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID,
579: LAST_UPDATED_BY = fnd_global.user_id,
580: LAST_UPDATE_DATE = SYSDATE,
581: CREATED_BY = fnd_global.user_id,
582: CREATION_DATE = SYSDATE

Line 579: LAST_UPDATED_BY = fnd_global.user_id,

575: UPDATE ZPB_DC_DISTRIBUTORS
576: SET DISTRIBUTION_DATE = SYSDATE,
577: APPROVER_TYPE = l_approver_type,
578: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID,
579: LAST_UPDATED_BY = fnd_global.user_id,
580: LAST_UPDATE_DATE = SYSDATE,
581: CREATED_BY = fnd_global.user_id,
582: CREATION_DATE = SYSDATE
583: WHERE object_id = p_object_id;

Line 581: CREATED_BY = fnd_global.user_id,

577: APPROVER_TYPE = l_approver_type,
578: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID,
579: LAST_UPDATED_BY = fnd_global.user_id,
580: LAST_UPDATE_DATE = SYSDATE,
581: CREATED_BY = fnd_global.user_id,
582: CREATION_DATE = SYSDATE
583: WHERE object_id = p_object_id;
584: UPDATE ZPB_DC_OBJECTS
585: SET DISTRIBUTOR_USER_ID = p_distributor_user_id,

Line 594: LAST_UPDATED_BY = fnd_global.user_id,

590: FREEZE_FLAG = 'N',
591: COPY_INSTANCE_DATA_FLAG = l_instance_flag,
592: --WHO columns
593: LAST_UPDATE_DATE = SYSDATE,
594: LAST_UPDATED_BY = fnd_global.user_id,
595: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
596: WHERE object_id = p_object_id;
597:
598: END IF; -- insert or update

Line 595: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID

591: COPY_INSTANCE_DATA_FLAG = l_instance_flag,
592: --WHO columns
593: LAST_UPDATE_DATE = SYSDATE,
594: LAST_UPDATED_BY = fnd_global.user_id,
595: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
596: WHERE object_id = p_object_id;
597:
598: END IF; -- insert or update
599:

Line 1040: fnd_global.user_id,

1036: l_ac_template_id,
1037: p_ac_id,
1038: p_instance_id,
1039: p_task_id,
1040: fnd_global.user_id,
1041: -100,
1042: 'M',
1043: l_status,
1044: l_template_name,

Line 1067: fnd_global.user_id,

1063: 'N',
1064: 'Y',
1065: 'Y',
1066: SYSDATE,
1067: fnd_global.user_id,
1068: SYSDATE,
1069: fnd_global.user_id,
1070: fnd_global.LOGIN_ID,
1071: l_currency_flag,

Line 1069: fnd_global.user_id,

1065: 'Y',
1066: SYSDATE,
1067: fnd_global.user_id,
1068: SYSDATE,
1069: fnd_global.user_id,
1070: fnd_global.LOGIN_ID,
1071: l_currency_flag,
1072: l_viewType,
1073: l_bus_area_id,

Line 1070: fnd_global.LOGIN_ID,

1066: SYSDATE,
1067: fnd_global.user_id,
1068: SYSDATE,
1069: fnd_global.user_id,
1070: fnd_global.LOGIN_ID,
1071: l_currency_flag,
1072: l_viewType,
1073: l_bus_area_id,
1074: l_multiple_submissions_flag);

Line 1089: fnd_global.LOGIN_ID ,

1085: CREATED_BY) Values (
1086: l_object_m_id ,
1087: '' ,
1088: l_short_instr_text ,
1089: fnd_global.LOGIN_ID ,
1090: SYSDATE ,
1091: fnd_global.user_id ,
1092: SYSDATE ,
1093: fnd_global.user_id

Line 1091: fnd_global.user_id ,

1087: '' ,
1088: l_short_instr_text ,
1089: fnd_global.LOGIN_ID ,
1090: SYSDATE ,
1091: fnd_global.user_id ,
1092: SYSDATE ,
1093: fnd_global.user_id
1094: );
1095:

Line 1093: fnd_global.user_id

1089: fnd_global.LOGIN_ID ,
1090: SYSDATE ,
1091: fnd_global.user_id ,
1092: SYSDATE ,
1093: fnd_global.user_id
1094: );
1095:
1096: /* Generate an editable version of the template.
1097: controller make changes then distribute. so the changes be copied

Line 1148: fnd_global.user_id,

1144: l_ac_template_id,
1145: p_ac_id,
1146: p_instance_id,
1147: p_task_id,
1148: fnd_global.user_id,
1149: -100,
1150: 'E',
1151: l_status,
1152: l_template_name,

Line 1175: fnd_global.user_id,

1171: 'N',
1172: 'Y',
1173: 'Y',
1174: SYSDATE,
1175: fnd_global.user_id,
1176: SYSDATE,
1177: fnd_global.user_id,
1178: fnd_global.LOGIN_ID,
1179: l_currency_flag,

Line 1177: fnd_global.user_id,

1173: 'Y',
1174: SYSDATE,
1175: fnd_global.user_id,
1176: SYSDATE,
1177: fnd_global.user_id,
1178: fnd_global.LOGIN_ID,
1179: l_currency_flag,
1180: l_viewType,
1181: l_bus_area_id,

Line 1178: fnd_global.LOGIN_ID,

1174: SYSDATE,
1175: fnd_global.user_id,
1176: SYSDATE,
1177: fnd_global.user_id,
1178: fnd_global.LOGIN_ID,
1179: l_currency_flag,
1180: l_viewType,
1181: l_bus_area_id,
1182: l_multiple_submissions_flag);

Line 1198: fnd_global.LOGIN_ID ,

1194: CREATED_BY) Values (
1195: l_object_e_id ,
1196: '' ,
1197: l_short_instr_text ,
1198: fnd_global.LOGIN_ID ,
1199: SYSDATE ,
1200: fnd_global.user_id ,
1201: SYSDATE ,
1202: fnd_global.user_id

Line 1200: fnd_global.user_id ,

1196: '' ,
1197: l_short_instr_text ,
1198: fnd_global.LOGIN_ID ,
1199: SYSDATE ,
1200: fnd_global.user_id ,
1201: SYSDATE ,
1202: fnd_global.user_id
1203: );
1204:

Line 1202: fnd_global.user_id

1198: fnd_global.LOGIN_ID ,
1199: SYSDATE ,
1200: fnd_global.user_id ,
1201: SYSDATE ,
1202: fnd_global.user_id
1203: );
1204:
1205:
1206: /* Generate a controller worksheet, need to set measures flag

Line 1257: fnd_global.user_id,

1253: l_ac_template_id,
1254: p_ac_id,
1255: p_instance_id,
1256: p_task_id,
1257: fnd_global.user_id,
1258: -100,
1259: 'C',
1260: l_template_name,
1261: 'DISTRIBUTION_PENDING',

Line 1284: fnd_global.user_id,

1280: 'N',
1281: 'Y',
1282: 'Y',
1283: SYSDATE,
1284: fnd_global.user_id,
1285: SYSDATE,
1286: fnd_global.user_id,
1287: fnd_global.LOGIN_ID,
1288: l_currency_flag,

Line 1286: fnd_global.user_id,

1282: 'Y',
1283: SYSDATE,
1284: fnd_global.user_id,
1285: SYSDATE,
1286: fnd_global.user_id,
1287: fnd_global.LOGIN_ID,
1288: l_currency_flag,
1289: l_viewType,
1290: l_bus_area_id,

Line 1287: fnd_global.LOGIN_ID,

1283: SYSDATE,
1284: fnd_global.user_id,
1285: SYSDATE,
1286: fnd_global.user_id,
1287: fnd_global.LOGIN_ID,
1288: l_currency_flag,
1289: l_viewType,
1290: l_bus_area_id,
1291: l_multiple_submissions_flag);

Line 2795: LAST_UPDATED_BY = fnd_global.USER_ID,

2791: PERSONAL_TARGET_QUERY_FLAG = 'N',
2792: CREATE_SOLVE_PROGRAM_FLAG = 'Y',
2793: INSTRUCTION_TEXT_ID = e_rec.instruction_text_id,
2794: DEADLINE_DATE = e_rec.deadline_date,
2795: LAST_UPDATED_BY = fnd_global.USER_ID,
2796: LAST_UPDATE_DATE = SYSDATE,
2797: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
2798: WHERE TEMPLATE_ID = p_template_id
2799: AND OBJECT_TYPE = 'C';

Line 2797: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID

2793: INSTRUCTION_TEXT_ID = e_rec.instruction_text_id,
2794: DEADLINE_DATE = e_rec.deadline_date,
2795: LAST_UPDATED_BY = fnd_global.USER_ID,
2796: LAST_UPDATE_DATE = SYSDATE,
2797: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
2798: WHERE TEMPLATE_ID = p_template_id
2799: AND OBJECT_TYPE = 'C';
2800: END LOOP;
2801:

Line 2805: LAST_UPDATED_BY = fnd_global.USER_ID,

2801:
2802: UPDATE ZPB_DC_OBJECTS
2803: SET REVIEW_COMPLETE_FLAG = 'Y',
2804: STATUS = 'REVIEW_COMPLETED',
2805: LAST_UPDATED_BY = fnd_global.USER_ID,
2806: LAST_UPDATE_DATE = SYSDATE,
2807: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
2808: WHERE TEMPLATE_ID = p_template_id
2809: AND OBJECT_TYPE in ('E','M');

Line 2807: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID

2803: SET REVIEW_COMPLETE_FLAG = 'Y',
2804: STATUS = 'REVIEW_COMPLETED',
2805: LAST_UPDATED_BY = fnd_global.USER_ID,
2806: LAST_UPDATE_DATE = SYSDATE,
2807: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
2808: WHERE TEMPLATE_ID = p_template_id
2809: AND OBJECT_TYPE in ('E','M');
2810:
2811: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 3168: LAST_UPDATED_BY = fnd_global.USER_ID,

3164: -- API Body
3165: UPDATE zpb_dc_objects
3166: SET copy_source_type_flag = 'Y',
3167: create_solve_program_flag = 'Y',
3168: LAST_UPDATED_BY = fnd_global.USER_ID,
3169: LAST_UPDATE_DATE = SYSDATE,
3170: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
3171: WHERE ac_instance_id = p_ac_instance_id;
3172:

Line 3170: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID

3166: SET copy_source_type_flag = 'Y',
3167: create_solve_program_flag = 'Y',
3168: LAST_UPDATED_BY = fnd_global.USER_ID,
3169: LAST_UPDATE_DATE = SYSDATE,
3170: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
3171: WHERE ac_instance_id = p_ac_instance_id;
3172:
3173: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
3174: p_data => x_msg_data );