APPS.JTF_UM_APPROVALS_PKG dependencies on JTF_UM_APPROVERS

Line 101: insert into JTF_UM_APPROVERS (

97: ) is
98: begin
99: JTF_DEBUG_PUB.LOG_PARAMETERS( p_module => 'JTF.UM.PLSQL.BUGTEST',
100: p_message => 'bef insert approver');
101: insert into JTF_UM_APPROVERS (
102: APPROVER_ID,
103: APPROVAL_ID,
104: APPROVER_SEQ,
105: EFFECTIVE_START_DATE,

Line 114: JTF_UM_APPROVERS_S.NEXTVAL,

110: LAST_UPDATE_LOGIN,
111: USER_ID,
112: ORG_PARTY_ID
113: ) values (
114: JTF_UM_APPROVERS_S.NEXTVAL,
115: X_APPROVAL_ID,
116: X_APPROVAL_SEQ,
117: X_EFFECTIVE_START_DATE,
118: X_CREATED_BY,

Line 348: update JTF_UM_APPROVERS set

344: X_USER_ID in NUMBER,
345: X_ORG_PARTY_ID in NUMBER
346: ) is
347: begin
348: update JTF_UM_APPROVERS set
349: APPROVAL_ID = X_APPROVAL_ID,
350: APPROVER_SEQ = X_APPROVAL_SEQ,
351: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
352: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 375: update JTF_UM_APPROVERS set

371: X_EFFECTIVE_END_DATE in DATE,
372: X_USER_ID in NUMBER
373: ) is
374: begin
375: update JTF_UM_APPROVERS set
376: APPROVAL_ID = X_APPROVAL_ID,
377: APPROVER_SEQ = X_APPROVER_SEQ,
378: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
379: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 404: cursor C is select ROWID from JTF_UM_APPROVERS

400: X_LAST_UPDATE_DATE in DATE,
401: X_LAST_UPDATED_BY in NUMBER,
402: X_LAST_UPDATE_LOGIN in NUMBER
403: ) is
404: cursor C is select ROWID from JTF_UM_APPROVERS
405: where APPROVER_ID = X_APPROVER_ID
406: ;
407: begin
408: insert into JTF_UM_APPROVERS (

Line 408: insert into JTF_UM_APPROVERS (

404: cursor C is select ROWID from JTF_UM_APPROVERS
405: where APPROVER_ID = X_APPROVER_ID
406: ;
407: begin
408: insert into JTF_UM_APPROVERS (
409: EFFECTIVE_END_DATE,
410: APPROVAL_ID,
411: USER_ID,
412: APPROVER_SEQ,

Line 426: JTF_UM_APPROVERS_S.NEXTVAL,

422: X_APPROVAL_ID,
423: X_USER_ID,
424: X_APPROVER_SEQ,
425: X_EFFECTIVE_START_DATE,
426: JTF_UM_APPROVERS_S.NEXTVAL,
427: X_CREATION_DATE,
428: X_CREATED_BY,
429: X_LAST_UPDATE_DATE,
430: X_LAST_UPDATED_BY,

Line 471: from JTF_UM_APPROVERS

467: -- end if;
468:
469: select count(*)
470: into h_record_exists
471: from JTF_UM_APPROVERS
472: where USER_ID = X_USER_ID
473: and APPROVAL_ID = X_APPROVAL_ID
474: and APPROVER_SEQ = X_APPROVER_SEQ
475: and EFFECTIVE_START_DATE = X_EFFECTIVE_START_DATE;

Line 505: from JTF_UM_APPROVERS

501: else
502: -- selecting the approver_id as it is needed for update
503: select APPROVER_ID
504: into l_approver_id
505: from JTF_UM_APPROVERS
506: where USER_ID = X_USER_ID
507: and APPROVAL_ID = X_APPROVAL_ID
508: and EFFECTIVE_START_DATE = X_EFFECTIVE_START_DATE;
509:

Line 518: FROM JTF_UM_APPROVERS

514: -- there is a row for this app_id and this app_short_name
515: -- Exception is thrown otherwise.
516: select LAST_UPDATED_BY, LAST_UPDATE_DATE
517: into db_luby, db_ludate
518: FROM JTF_UM_APPROVERS
519: where APPROVER_ID = l_approver_id;
520:
521: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
522: db_ludate, X_CUSTOM_MODE)) then

Line 563: delete from JTF_UM_APPROVERS

559: procedure DELETE_APPROVERS_ROW (
560: X_APPROVER_ID in NUMBER
561: ) is
562: begin
563: delete from JTF_UM_APPROVERS
564: where APPROVER_ID = X_APPROVER_ID;
565:
566: if (sql%notfound) then
567: raise no_data_found;

Line 690: cursor ap is select approval_id from jtf_um_approvers

686: p_approval_id IN NUMBER,
687: p_org_party_id IN NUMBER
688: )
689: return varchar2 is
690: cursor ap is select approval_id from jtf_um_approvers
691: where approval_id = p_approval_id
692: and org_party_id = p_org_party_id
693: and (effective_end_date is null or effective_end_date > sysdate);
694: p_result varchar2(1):= 'N';