APPS.XTR_MISC_P dependencies on XTR_CONFIRMATION_DETAILS

Line 491: insert into xtr_confirmation_details(

487:
488: /************************
489:
490: if (nvl(p_cparty_advice,'N') = 'N' and nvl(p_client_advice,'N')= 'N') or (nvl(p_org_flag,'~') = 'U') then
491: insert into xtr_confirmation_details(
492: ACTION_TYPE,COMPANY_CODE,CONFO_PARTY_CODE,CONFO_VALIDATION_BOTH,
493: CPARTY_CODE,DATE_ACTION_INITIATED,DEAL_NO,STATUS_CODE,TRANSACTION_NO,AMOUNT,AMOUNT_TYPE,CLIENT_CODE,
494: CURRENCY,DEAL_SUBTYPE,DEAL_TYPE,CONFIRMATION_VALIDATED_BY,CONFIRMATION_VALIDATED_ON)
495: values(p_action_type,p_company_code,NULL,'V',p_cparty_code,trunc(p_date_created),

Line 503: insert into xtr_confirmation_details(

499: --
500: open chk_confo_reqd(p_cparty_code );
501: fetch chk_confo_reqd into l_dumy_num;
502: if chk_confo_reqd%NOTFOUND then
503: insert into xtr_confirmation_details(
504: ACTION_TYPE,COMPANY_CODE,CONFO_PARTY_CODE,CONFO_VALIDATION_BOTH,
505: CPARTY_CODE,DATE_ACTION_INITIATED,DEAL_NO,STATUS_CODE,TRANSACTION_NO,
506: AMOUNT,AMOUNT_TYPE,CLIENT_CODE,CURRENCY,DEAL_SUBTYPE,DEAL_TYPE,
507: CONFIRMATION_VALIDATED_BY,CONFIRMATION_VALIDATED_ON)

Line 512: insert into xtr_confirmation_details(

508: values( p_action_type,p_company_code, NULL,'V',p_cparty_code,trunc(p_date_created),
509: p_deal_number,p_status_code, p_transaction_number, p_amount,NULL,p_client_code,
510: p_currency,p_deal_subtype,p_deal_type,confirmed_by,confirmed_on);
511: else
512: insert into xtr_confirmation_details(
513: ACTION_TYPE,COMPANY_CODE,CONFO_PARTY_CODE,CONFO_VALIDATION_BOTH,
514: CPARTY_CODE,DATE_ACTION_INITIATED,DEAL_NO,STATUS_CODE,TRANSACTION_NO,AMOUNT,
515: AMOUNT_TYPE,CLIENT_CODE,CURRENCY,DEAL_SUBTYPE,DEAL_TYPE,
516: CONFIRMATION_VALIDATED_BY,CONFIRMATION_VALIDATED_ON)

Line 528: insert into xtr_confirmation_details(

524: --
525: open chk_confo_reqd(p_client_code);
526: fetch chk_confo_reqd into l_dumy_num;
527: if chk_confo_reqd%NOTFOUND then
528: insert into xtr_confirmation_details(
529: ACTION_TYPE,COMPANY_CODE,CONFO_PARTY_CODE,CONFO_VALIDATION_BOTH,
530: CPARTY_CODE,DATE_ACTION_INITIATED,DEAL_NO,STATUS_CODE,TRANSACTION_NO,AMOUNT,
531: AMOUNT_TYPE,CLIENT_CODE,CURRENCY,DEAL_SUBTYPE,DEAL_TYPE,
532: CONFIRMATION_VALIDATED_BY,CONFIRMATION_VALIDATED_ON)

Line 537: insert into xtr_confirmation_details(

533: values(p_action_type,p_company_code, NULL,'V',p_cparty_code,trunc(p_date_created),
534: p_deal_number,p_status_code,p_transaction_number,p_amount,NULL,p_client_code,
535: p_currency,p_deal_subtype,p_deal_type,confirmed_by,confirmed_on);
536: else
537: insert into xtr_confirmation_details(
538: ACTION_TYPE,COMPANY_CODE,CONFO_PARTY_CODE,CONFO_VALIDATION_BOTH,
539: CPARTY_CODE,DATE_ACTION_INITIATED,DEAL_NO,STATUS_CODE,TRANSACTION_NO,AMOUNT,
540: AMOUNT_TYPE,CLIENT_CODE,CURRENCY,DEAL_SUBTYPE,DEAL_TYPE,
541: CONFIRMATION_VALIDATED_BY,CONFIRMATION_VALIDATED_ON)

Line 555: insert into xtr_confirmation_details(

551:
552: open chk_confo_reqd(p_cparty_code);
553: fetch chk_confo_reqd into l_dumy_num;
554: if chk_confo_reqd%NOTFOUND then
555: insert into xtr_confirmation_details(
556: ACTION_TYPE,COMPANY_CODE,CONFO_PARTY_CODE,CONFO_VALIDATION_BOTH,
557: CPARTY_CODE,DATE_ACTION_INITIATED,DEAL_NO,STATUS_CODE,TRANSACTION_NO,AMOUNT,
558: AMOUNT_TYPE,CLIENT_CODE,CURRENCY,DEAL_SUBTYPE,DEAL_TYPE,
559: CONFIRMATION_VALIDATED_BY,CONFIRMATION_VALIDATED_ON)

Line 564: insert into xtr_confirmation_details(

560: values(p_action_type,p_company_code,NULL,'V',p_cparty_code,trunc(p_date_created),
561: p_deal_number,p_status_code,p_transaction_number,p_amount,NULL,p_client_code,
562: p_currency,p_deal_subtype,p_deal_type,confirmed_by,confirmed_on);
563: else
564: insert into xtr_confirmation_details(
565: ACTION_TYPE,COMPANY_CODE,CONFO_PARTY_CODE,CONFO_VALIDATION_BOTH,
566: CPARTY_CODE,DATE_ACTION_INITIATED,DEAL_NO,STATUS_CODE,TRANSACTION_NO,AMOUNT,
567: AMOUNT_TYPE,CLIENT_CODE,CURRENCY,DEAL_SUBTYPE,DEAL_TYPE,
568: CONFIRMATION_VALIDATED_BY,CONFIRMATION_VALIDATED_ON)

Line 578: insert into xtr_confirmation_details(

574: --
575: open chk_confo_reqd(p_client_code );
576: fetch chk_confo_reqd into l_dumy_num;
577: if chk_confo_reqd%FOUND then
578: insert into xtr_confirmation_details(
579: ACTION_TYPE,COMPANY_CODE,CONFO_PARTY_CODE,CONFO_VALIDATION_BOTH,
580: CPARTY_CODE,DATE_ACTION_INITIATED,DEAL_NO,STATUS_CODE,TRANSACTION_NO,AMOUNT,
581: AMOUNT_TYPE,CLIENT_CODE,CURRENCY,DEAL_SUBTYPE,DEAL_TYPE)
582: values(p_action_type,p_company_code,p_client_code,'C',p_cparty_code,trunc(p_date_created),