DBA Data[Home] [Help]

APPS.OKC_REP_WF_PVT dependencies on OKC_REP_CON_APPROVALS

Line 926: l_contract_id OKC_REP_CON_APPROVALS.contract_id%type;

922: funcmode IN varchar2,
923: resultout OUT nocopy varchar2
924: ) IS
925:
926: l_contract_id OKC_REP_CON_APPROVALS.contract_id%type;
927: l_contract_version OKC_REP_CON_APPROVALS.contract_version_num%type;
928: l_approver_record2 ame_util.approverRecord2;
929: l_approver_id number;
930: l_approval_status VARCHAR2(30);

Line 927: l_contract_version OKC_REP_CON_APPROVALS.contract_version_num%type;

923: resultout OUT nocopy varchar2
924: ) IS
925:
926: l_contract_id OKC_REP_CON_APPROVALS.contract_id%type;
927: l_contract_version OKC_REP_CON_APPROVALS.contract_version_num%type;
928: l_approver_record2 ame_util.approverRecord2;
929: l_approver_id number;
930: l_approval_status VARCHAR2(30);
931: l_recipient_name FND_USER.user_name%type;

Line 932: l_action_code OKC_REP_CON_APPROVALS.action_code%type;

928: l_approver_record2 ame_util.approverRecord2;
929: l_approver_id number;
930: l_approval_status VARCHAR2(30);
931: l_recipient_name FND_USER.user_name%type;
932: l_action_code OKC_REP_CON_APPROVALS.action_code%type;
933: l_wf_note VARCHAR2(2000);
934: l_api_name VARCHAR2(30);
935: l_return_status VARCHAR2(1);
936: l_msg_count NUMBER;

Line 1260: l_contract_id OKC_REP_CON_APPROVALS.contract_id%type;

1256: funcmode IN varchar2,
1257: resultout OUT nocopy varchar2
1258: ) IS
1259:
1260: l_contract_id OKC_REP_CON_APPROVALS.contract_id%type;
1261: l_contract_version OKC_REP_CON_APPROVALS.contract_version_num%type;
1262: l_approver_record2 ame_util.approverRecord2;
1263: l_notification_record ame_util2.notificationRecord;
1264: l_approver_id number;

Line 1261: l_contract_version OKC_REP_CON_APPROVALS.contract_version_num%type;

1257: resultout OUT nocopy varchar2
1258: ) IS
1259:
1260: l_contract_id OKC_REP_CON_APPROVALS.contract_id%type;
1261: l_contract_version OKC_REP_CON_APPROVALS.contract_version_num%type;
1262: l_approver_record2 ame_util.approverRecord2;
1263: l_notification_record ame_util2.notificationRecord;
1264: l_approver_id number;
1265: l_approval_status VARCHAR2(30);

Line 1267: l_action_code OKC_REP_CON_APPROVALS.action_code%type;

1263: l_notification_record ame_util2.notificationRecord;
1264: l_approver_id number;
1265: l_approval_status VARCHAR2(30);
1266: l_recipient_name FND_USER.user_name%type;
1267: l_action_code OKC_REP_CON_APPROVALS.action_code%type;
1268: l_wf_note VARCHAR2(2000);
1269: l_api_name VARCHAR2(30);
1270: l_return_status VARCHAR2(1);
1271: l_msg_count NUMBER;