APPS.XTR_MISC_P dependencies on XTR_CONFIRMATION_DETAILS

Line 504: insert into xtr_confirmation_details(

500:
501: /************************
502:
503: if (nvl(p_cparty_advice,'N') = 'N' and nvl(p_client_advice,'N')= 'N') or (nvl(p_org_flag,'~') = 'U') then
504: insert into xtr_confirmation_details(
505: ACTION_TYPE,COMPANY_CODE,CONFO_PARTY_CODE,CONFO_VALIDATION_BOTH,
506: CPARTY_CODE,DATE_ACTION_INITIATED,DEAL_NO,STATUS_CODE,TRANSACTION_NO,AMOUNT,AMOUNT_TYPE,CLIENT_CODE,
507: CURRENCY,DEAL_SUBTYPE,DEAL_TYPE,CONFIRMATION_VALIDATED_BY,CONFIRMATION_VALIDATED_ON)
508: values(p_action_type,p_company_code,NULL,'V',p_cparty_code,trunc(p_date_created),

Line 516: insert into xtr_confirmation_details(

512: --
513: open chk_confo_reqd(p_cparty_code );
514: fetch chk_confo_reqd into l_dumy_num;
515: if chk_confo_reqd%NOTFOUND then
516: insert into xtr_confirmation_details(
517: ACTION_TYPE,COMPANY_CODE,CONFO_PARTY_CODE,CONFO_VALIDATION_BOTH,
518: CPARTY_CODE,DATE_ACTION_INITIATED,DEAL_NO,STATUS_CODE,TRANSACTION_NO,
519: AMOUNT,AMOUNT_TYPE,CLIENT_CODE,CURRENCY,DEAL_SUBTYPE,DEAL_TYPE,
520: CONFIRMATION_VALIDATED_BY,CONFIRMATION_VALIDATED_ON)

Line 525: insert into xtr_confirmation_details(

521: values( p_action_type,p_company_code, NULL,'V',p_cparty_code,trunc(p_date_created),
522: p_deal_number,p_status_code, p_transaction_number, l_amount,NULL,p_client_code,
523: p_currency,p_deal_subtype,p_deal_type,confirmed_by,confirmed_on);
524: else
525: insert into xtr_confirmation_details(
526: ACTION_TYPE,COMPANY_CODE,CONFO_PARTY_CODE,CONFO_VALIDATION_BOTH,
527: CPARTY_CODE,DATE_ACTION_INITIATED,DEAL_NO,STATUS_CODE,TRANSACTION_NO,AMOUNT,
528: AMOUNT_TYPE,CLIENT_CODE,CURRENCY,DEAL_SUBTYPE,DEAL_TYPE,
529: CONFIRMATION_VALIDATED_BY,CONFIRMATION_VALIDATED_ON)

Line 541: insert into xtr_confirmation_details(

537: --
538: open chk_confo_reqd(p_client_code);
539: fetch chk_confo_reqd into l_dumy_num;
540: if chk_confo_reqd%NOTFOUND then
541: insert into xtr_confirmation_details(
542: ACTION_TYPE,COMPANY_CODE,CONFO_PARTY_CODE,CONFO_VALIDATION_BOTH,
543: CPARTY_CODE,DATE_ACTION_INITIATED,DEAL_NO,STATUS_CODE,TRANSACTION_NO,AMOUNT,
544: AMOUNT_TYPE,CLIENT_CODE,CURRENCY,DEAL_SUBTYPE,DEAL_TYPE,
545: CONFIRMATION_VALIDATED_BY,CONFIRMATION_VALIDATED_ON)

Line 550: insert into xtr_confirmation_details(

546: values(p_action_type,p_company_code, NULL,'V',p_cparty_code,trunc(p_date_created),
547: p_deal_number,p_status_code,p_transaction_number,l_amount,NULL,p_client_code,
548: p_currency,p_deal_subtype,p_deal_type,confirmed_by,confirmed_on);
549: else
550: insert into xtr_confirmation_details(
551: ACTION_TYPE,COMPANY_CODE,CONFO_PARTY_CODE,CONFO_VALIDATION_BOTH,
552: CPARTY_CODE,DATE_ACTION_INITIATED,DEAL_NO,STATUS_CODE,TRANSACTION_NO,AMOUNT,
553: AMOUNT_TYPE,CLIENT_CODE,CURRENCY,DEAL_SUBTYPE,DEAL_TYPE,
554: CONFIRMATION_VALIDATED_BY,CONFIRMATION_VALIDATED_ON)

Line 568: insert into xtr_confirmation_details(

564:
565: open chk_confo_reqd(p_cparty_code);
566: fetch chk_confo_reqd into l_dumy_num;
567: if chk_confo_reqd%NOTFOUND then
568: insert into xtr_confirmation_details(
569: ACTION_TYPE,COMPANY_CODE,CONFO_PARTY_CODE,CONFO_VALIDATION_BOTH,
570: CPARTY_CODE,DATE_ACTION_INITIATED,DEAL_NO,STATUS_CODE,TRANSACTION_NO,AMOUNT,
571: AMOUNT_TYPE,CLIENT_CODE,CURRENCY,DEAL_SUBTYPE,DEAL_TYPE,
572: CONFIRMATION_VALIDATED_BY,CONFIRMATION_VALIDATED_ON)

Line 577: insert into xtr_confirmation_details(

573: values(p_action_type,p_company_code,NULL,'V',p_cparty_code,trunc(p_date_created),
574: p_deal_number,p_status_code,p_transaction_number,l_amount,NULL,p_client_code,
575: p_currency,p_deal_subtype,p_deal_type,confirmed_by,confirmed_on);
576: else
577: insert into xtr_confirmation_details(
578: ACTION_TYPE,COMPANY_CODE,CONFO_PARTY_CODE,CONFO_VALIDATION_BOTH,
579: CPARTY_CODE,DATE_ACTION_INITIATED,DEAL_NO,STATUS_CODE,TRANSACTION_NO,AMOUNT,
580: AMOUNT_TYPE,CLIENT_CODE,CURRENCY,DEAL_SUBTYPE,DEAL_TYPE,
581: CONFIRMATION_VALIDATED_BY,CONFIRMATION_VALIDATED_ON)

Line 591: insert into xtr_confirmation_details(

587: --
588: open chk_confo_reqd(p_client_code );
589: fetch chk_confo_reqd into l_dumy_num;
590: if chk_confo_reqd%FOUND then
591: insert into xtr_confirmation_details(
592: ACTION_TYPE,COMPANY_CODE,CONFO_PARTY_CODE,CONFO_VALIDATION_BOTH,
593: CPARTY_CODE,DATE_ACTION_INITIATED,DEAL_NO,STATUS_CODE,TRANSACTION_NO,AMOUNT,
594: AMOUNT_TYPE,CLIENT_CODE,CURRENCY,DEAL_SUBTYPE,DEAL_TYPE)
595: values(p_action_type,p_company_code,p_client_code,'C',p_cparty_code,trunc(p_date_created),