DBA Data[Home] [Help]

APPS.PA_PROGRESS_REPORT_PKG dependencies on FND_GLOBAL

Line 92: fnd_global.user_id,

88: p_canceled_date,
89: p_report_Type_id,
90: 1,
91: 1,
92: fnd_global.user_id,
93: fnd_global.user_id,
94: sysdate,
95: sysdate,
96: fnd_global.user_id) returning version_id INTO l_version_id;

Line 93: fnd_global.user_id,

89: p_report_Type_id,
90: 1,
91: 1,
92: fnd_global.user_id,
93: fnd_global.user_id,
94: sysdate,
95: sysdate,
96: fnd_global.user_id) returning version_id INTO l_version_id;
97:

Line 96: fnd_global.user_id) returning version_id INTO l_version_id;

92: fnd_global.user_id,
93: fnd_global.user_id,
94: sysdate,
95: sysdate,
96: fnd_global.user_id) returning version_id INTO l_version_id;
97:
98: open c;
99: fetch c into l_ROWID;
100: if (c%notfound) then

Line 169: LAST_UPDATED_BY = fnd_global.user_id,

165: comments =Nvl(p_comments, comments),
166: canceled_date = Nvl(p_canceled_date, canceled_date),
167: report_Type_id = nvl(p_report_Type_id,report_Type_id),
168:
169: LAST_UPDATED_BY = fnd_global.user_id,
170: LAST_UPDATE_DATE = sysdate,
171: LAST_UPDATE_LOGIN = fnd_global.login_id
172: where VERSION_ID = p_version_id
173: AND record_version_number = Nvl(p_record_version_number, record_version_number)

Line 171: LAST_UPDATE_LOGIN = fnd_global.login_id

167: report_Type_id = nvl(p_report_Type_id,report_Type_id),
168:
169: LAST_UPDATED_BY = fnd_global.user_id,
170: LAST_UPDATE_DATE = sysdate,
171: LAST_UPDATE_LOGIN = fnd_global.login_id
172: where VERSION_ID = p_version_id
173: AND record_version_number = Nvl(p_record_version_number, record_version_number)
174: AND summary_version_number = Nvl(p_summary_version_number, summary_version_number);
175:

Line 381: fnd_global.user_id,

377: P_UDS_ATTRIBUTE17,
378: P_UDS_ATTRIBUTE18,
379: P_UDS_ATTRIBUTE19,
380: P_UDS_ATTRIBUTE20,
381: fnd_global.user_id,
382: fnd_global.user_id,
383: sysdate,
384: sysdate,
385: fnd_global.user_id) returning record_sequence INTO L_RECORD_SEQUENCE;

Line 382: fnd_global.user_id,

378: P_UDS_ATTRIBUTE18,
379: P_UDS_ATTRIBUTE19,
380: P_UDS_ATTRIBUTE20,
381: fnd_global.user_id,
382: fnd_global.user_id,
383: sysdate,
384: sysdate,
385: fnd_global.user_id) returning record_sequence INTO L_RECORD_SEQUENCE;
386:

Line 385: fnd_global.user_id) returning record_sequence INTO L_RECORD_SEQUENCE;

381: fnd_global.user_id,
382: fnd_global.user_id,
383: sysdate,
384: sysdate,
385: fnd_global.user_id) returning record_sequence INTO L_RECORD_SEQUENCE;
386:
387:
388: open c;
389: fetch c into l_ROWID;

Line 508: LAST_UPDATED_BY = fnd_global.user_id,

504: UDS_ATTRIBUTE17 = P_UDS_ATTRIBUTE14,
505: UDS_ATTRIBUTE18 = P_UDS_ATTRIBUTE15,
506: UDS_ATTRIBUTE19 = P_UDS_ATTRIBUTE16,
507: UDS_ATTRIBUTE20 = P_UDS_ATTRIBUTE17,
508: LAST_UPDATED_BY = fnd_global.user_id,
509: LAST_UPDATE_DATE = sysdate,
510: LAST_UPDATE_LOGIN = fnd_global.login_id
511: WHERE VERSION_ID = P_VERSION_ID
512: AND region_source_type = p_region_source_type

Line 510: LAST_UPDATE_LOGIN = fnd_global.login_id

506: UDS_ATTRIBUTE19 = P_UDS_ATTRIBUTE16,
507: UDS_ATTRIBUTE20 = P_UDS_ATTRIBUTE17,
508: LAST_UPDATED_BY = fnd_global.user_id,
509: LAST_UPDATE_DATE = sysdate,
510: LAST_UPDATE_LOGIN = fnd_global.login_id
511: WHERE VERSION_ID = P_VERSION_ID
512: AND region_source_type = p_region_source_type
513: AND region_code = p_region_code
514: AND record_sequence = p_record_sequence;

Line 713: fnd_global.user_id,

709: P_FINAL_PROGRESS_STATUS,
710: P_ROLLUP_PROGRESS_STATUS,
711:
712: 1,
713: fnd_global.user_id,
714: fnd_global.user_id,
715: sysdate,
716: sysdate,
717: fnd_global.user_id,

Line 714: fnd_global.user_id,

710: P_ROLLUP_PROGRESS_STATUS,
711:
712: 1,
713: fnd_global.user_id,
714: fnd_global.user_id,
715: sysdate,
716: sysdate,
717: fnd_global.user_id,
718: l_layout_id,

Line 717: fnd_global.user_id,

713: fnd_global.user_id,
714: fnd_global.user_id,
715: sysdate,
716: sysdate,
717: fnd_global.user_id,
718: l_layout_id,
719: p_report_type_id,
720: p_approver_source_id,
721: p_approver_source_type,

Line 803: LAST_UPDATED_BY = fnd_global.user_id,

799: approver_source_type = p_approver_source_type,
800: effective_from = p_effective_from,
801: effective_to = p_effective_to,
802: pers_function_name = p_function_name,
803: LAST_UPDATED_BY = fnd_global.user_id,
804: LAST_UPDATE_DATE = sysdate,
805: LAST_UPDATE_LOGIN = fnd_global.login_id
806: where object_page_layout_ID = p_object_page_layout_id
807: AND record_version_number = Nvl(p_record_version_number, record_version_number);

Line 805: LAST_UPDATE_LOGIN = fnd_global.login_id

801: effective_to = p_effective_to,
802: pers_function_name = p_function_name,
803: LAST_UPDATED_BY = fnd_global.user_id,
804: LAST_UPDATE_DATE = sysdate,
805: LAST_UPDATE_LOGIN = fnd_global.login_id
806: where object_page_layout_ID = p_object_page_layout_id
807: AND record_version_number = Nvl(p_record_version_number, record_version_number);
808:
809: if (sql%notfound) then