APPS.OKC_REP_WF_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 90

        SELECT contract_type, contract_number, contract_name, contract_version_num
        FROM okc_rep_contracts_all
        WHERE contract_id = l_contract_id;

Line: 779

    PROCEDURE update_ame_status(
        itemtype  IN varchar2,
        itemkey   IN varchar2,
        actid     IN number,
        funcmode  IN varchar2,
        resultout OUT nocopy varchar2
    ) IS

    l_contract_id       OKC_REP_CON_APPROVALS.contract_id%type;

Line: 809

        SELECT fu.user_id user_id, fu.user_name user_name,
	fu1.user_id original_user_id,fu1.user_name original_user_name
        FROM   fnd_user fu, wf_notifications wfn, fnd_user fu1
        WHERE  fu.user_name = wfn.recipient_role
	AND    fu1.user_name = wfn.original_recipient
        AND    wfn.notification_id = p_notification_id ;

Line: 820

    l_api_name := 'update_ame_status';

Line: 824

                'Entered OKC_REP_WF_PVT.update_ame_status');

Line: 915

                ame_api2.updateApprovalStatus(
                applicationIdIn => G_APPLICATION_ID,
                transactionIdIn => fnd_number.number_to_canonical(l_contract_id),
                approverIn => l_approver_record2,
                transactionTypeIn => G_TRANSACTION_TYPE);

Line: 962

                  'Calling ame_api2.updateApprovalStatus');

Line: 964

            ame_api2.updateApprovalStatus(
                applicationIdIn => G_APPLICATION_ID,
                transactionIdIn => fnd_number.number_to_canonical(l_contract_id),
                approverIn => l_approver_record2,
                transactionTypeIn => G_TRANSACTION_TYPE);

Line: 977

             'Leaving OKC_REP_WF_PVT.update_ame_status from funcmode=RESPOND');

Line: 994

                 'Leaving OKC_REP_WF_PVT.update_ame_status from funcmode=RUN');

Line: 1003

                'In OKC_REP_WF_PVT.update_ame_status funcmode=TIMEOUT');

Line: 1035

             'Calling ame_api2.updateApprovalStatus');

Line: 1037

        ame_api2.updateApprovalStatus(
             applicationIdIn => G_APPLICATION_ID,
             transactionIdIn => fnd_number.number_to_canonical(l_contract_id),
             approverIn => l_approver_record2,
             transactionTypeIn => G_TRANSACTION_TYPE);

Line: 1046

                 'Leaving OKC_REP_WF_PVT.update_ame_status from funcmode=TIMEOUT');

Line: 1058

                 '618: Leaving OKC_REP_WF_PVT.update_ame_status with exceptions ' || sqlerrm);

Line: 1065

          'update_ame_status',
          itemtype,
          itemkey,
          to_char(actid),
          funcmode);

Line: 1071

    END update_ame_status;

Line: 1093

    PROCEDURE update_ame_status_detailed(
        itemtype  IN varchar2,
        itemkey   IN varchar2,
        actid     IN number,
        funcmode  IN varchar2,
        resultout OUT nocopy varchar2
    ) IS

    l_contract_id       OKC_REP_CON_APPROVALS.contract_id%type;

Line: 1124

        SELECT fu.user_id user_id, fu.user_name user_name,
	fu1.user_id original_user_id,fu1.user_name original_user_name
        FROM   fnd_user fu, wf_notifications wfn, fnd_user fu1
        WHERE  fu.user_name = wfn.recipient_role
	AND    fu1.user_name = wfn.original_recipient
        AND    wfn.notification_id = p_notification_id ;

Line: 1135

    l_api_name := 'update_ame_status';

Line: 1139

                'Entered OKC_REP_WF_PVT.update_ame_status_detailed');

Line: 1235

                  'Calling ame_api6.updateApprovalStatus');

Line: 1237

                ame_api6.updateApprovalStatus(
                applicationIdIn => G_APPLICATION_ID,
                transactionIdIn => fnd_number.number_to_canonical(l_contract_id),
                approverIn => l_approver_record2,
                transactionTypeIn => G_TRANSACTION_TYPE,
				notificationIn => l_notification_record);

Line: 1285

                  'Calling ame_api6.updateApprovalStatus');

Line: 1287

           ame_api6.updateApprovalStatus(
                applicationIdIn => G_APPLICATION_ID,
                transactionIdIn => fnd_number.number_to_canonical(l_contract_id),
                approverIn => l_approver_record2,
                transactionTypeIn => G_TRANSACTION_TYPE,
				notificationIn => l_notification_record);

Line: 1301

             'Leaving OKC_REP_WF_PVT.update_ame_status_detailed from funcmode=RESPOND');

Line: 1318

                 'Leaving OKC_REP_WF_PVT.update_ame_status_detailed from funcmode=RUN');

Line: 1327

                'In OKC_REP_WF_PVT.update_ame_status funcmode=TIMEOUT');

Line: 1359

             'Calling ame_api6.updateApprovalStatus');

Line: 1361

        ame_api6.updateApprovalStatus(
                applicationIdIn => G_APPLICATION_ID,
                transactionIdIn => fnd_number.number_to_canonical(l_contract_id),
                approverIn => l_approver_record2,
                transactionTypeIn => G_TRANSACTION_TYPE,
				notificationIn => l_notification_record);

Line: 1371

                 'Leaving OKC_REP_WF_PVT.update_ame_status_detailed from funcmode=TIMEOUT');

Line: 1383

                 '618: Leaving OKC_REP_WF_PVT.update_ame_status_detailed with exceptions ' || sqlerrm);

Line: 1390

          'update_ame_status_detailed',
          itemtype,
          itemkey,
          to_char(actid),
          funcmode);

Line: 1396

    END update_ame_status_detailed;

Line: 1831

	   SELECT item_key FROM wf_items
	      WHERE item_type=itemtype
		  AND item_key like itemkey || '_' || '%'
		  and end_date is null;

Line: 2195

     select 'Y'
      from okc_contract_docs
      where business_document_type = l_contract_type
      and business_document_id = l_contract_id
      AND request_id =  l_con_req_id;