682: l_org_id,
683: decode (p_doc_type,'OKE_SELL', 'OKC11510UPG:OKE', 'OKE_BUY', 'OKC11510UPG:OKE', 'OKC11510UPG'),
684: decode(p_doc_type,'OKS','N','Y'),
685: 1,
686: Fnd_Global.User_Id,
687: trunc(sysdate),
688: Fnd_Global.User_Id,
689: Fnd_Global.Login_Id,
690: trunc(sysdate)
684: decode(p_doc_type,'OKS','N','Y'),
685: 1,
686: Fnd_Global.User_Id,
687: trunc(sysdate),
688: Fnd_Global.User_Id,
689: Fnd_Global.Login_Id,
690: trunc(sysdate)
691: );
692:
685: 1,
686: Fnd_Global.User_Id,
687: trunc(sysdate),
688: Fnd_Global.User_Id,
689: Fnd_Global.Login_Id,
690: trunc(sysdate)
691: );
692:
693: INSERT INTO OKC_ALLOWED_TMPL_USAGES(
706: l_tmpl_id,
707: p_doc_type,
708: 'N',
709: 1,
710: Fnd_Global.User_Id,
711: trunc(sysdate),
712: Fnd_Global.User_Id,
713: Fnd_Global.Login_Id,
714: trunc(sysdate)
708: 'N',
709: 1,
710: Fnd_Global.User_Id,
711: trunc(sysdate),
712: Fnd_Global.User_Id,
713: Fnd_Global.Login_Id,
714: trunc(sysdate)
715: );
716: END IF;
709: 1,
710: Fnd_Global.User_Id,
711: trunc(sysdate),
712: Fnd_Global.User_Id,
713: Fnd_Global.Login_Id,
714: trunc(sysdate)
715: );
716: END IF;
717: IF l_tmpl_id IS NOT NULL THEN