APPS.OKC_REP_WF_PVT dependencies on OKC_REP_CON_APPROVALS

Line 787: l_contract_id OKC_REP_CON_APPROVALS.contract_id%type;

783: funcmode IN varchar2,
784: resultout OUT nocopy varchar2
785: ) IS
786:
787: l_contract_id OKC_REP_CON_APPROVALS.contract_id%type;
788: l_contract_version OKC_REP_CON_APPROVALS.contract_version_num%type;
789: l_approver_record2 ame_util.approverRecord2;
790: l_approver_id number;
791: l_approval_status VARCHAR2(30);

Line 788: l_contract_version OKC_REP_CON_APPROVALS.contract_version_num%type;

784: resultout OUT nocopy varchar2
785: ) IS
786:
787: l_contract_id OKC_REP_CON_APPROVALS.contract_id%type;
788: l_contract_version OKC_REP_CON_APPROVALS.contract_version_num%type;
789: l_approver_record2 ame_util.approverRecord2;
790: l_approver_id number;
791: l_approval_status VARCHAR2(30);
792: l_recipient_name FND_USER.user_name%type;

Line 793: l_action_code OKC_REP_CON_APPROVALS.action_code%type;

789: l_approver_record2 ame_util.approverRecord2;
790: l_approver_id number;
791: l_approval_status VARCHAR2(30);
792: l_recipient_name FND_USER.user_name%type;
793: l_action_code OKC_REP_CON_APPROVALS.action_code%type;
794: l_wf_note VARCHAR2(2000);
795: l_api_name VARCHAR2(30);
796: l_return_status VARCHAR2(1);
797: l_msg_count NUMBER;

Line 1101: l_contract_id OKC_REP_CON_APPROVALS.contract_id%type;

1097: funcmode IN varchar2,
1098: resultout OUT nocopy varchar2
1099: ) IS
1100:
1101: l_contract_id OKC_REP_CON_APPROVALS.contract_id%type;
1102: l_contract_version OKC_REP_CON_APPROVALS.contract_version_num%type;
1103: l_approver_record2 ame_util.approverRecord2;
1104: l_notification_record ame_util2.notificationRecord;
1105: l_approver_id number;

Line 1102: l_contract_version OKC_REP_CON_APPROVALS.contract_version_num%type;

1098: resultout OUT nocopy varchar2
1099: ) IS
1100:
1101: l_contract_id OKC_REP_CON_APPROVALS.contract_id%type;
1102: l_contract_version OKC_REP_CON_APPROVALS.contract_version_num%type;
1103: l_approver_record2 ame_util.approverRecord2;
1104: l_notification_record ame_util2.notificationRecord;
1105: l_approver_id number;
1106: l_approval_status VARCHAR2(30);

Line 1108: l_action_code OKC_REP_CON_APPROVALS.action_code%type;

1104: l_notification_record ame_util2.notificationRecord;
1105: l_approver_id number;
1106: l_approval_status VARCHAR2(30);
1107: l_recipient_name FND_USER.user_name%type;
1108: l_action_code OKC_REP_CON_APPROVALS.action_code%type;
1109: l_wf_note VARCHAR2(2000);
1110: l_api_name VARCHAR2(30);
1111: l_return_status VARCHAR2(1);
1112: l_msg_count NUMBER;