APPS.ASO_PUBLISH_MISC_INT dependencies on JTF_RS_RESOURCE_EXTNS

Line 88: l_first_name JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE;

84: l_messageName WF_MESSAGES.NAME%TYPE;
85: l_msgEnabled VARCHAR2(3) :='Y';
86:
87: l_resource_id number;
88: l_first_name JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE;
89: l_last_name JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE;
90: l_email_id JTF_RS_RESOURCE_EXTNS.SOURCE_EMAIL%TYPE;
91: l_full_name Varchar2(360);
92:

Line 89: l_last_name JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE;

85: l_msgEnabled VARCHAR2(3) :='Y';
86:
87: l_resource_id number;
88: l_first_name JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE;
89: l_last_name JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE;
90: l_email_id JTF_RS_RESOURCE_EXTNS.SOURCE_EMAIL%TYPE;
91: l_full_name Varchar2(360);
92:
93: l_quoteSourceSatusId Number := null;

Line 90: l_email_id JTF_RS_RESOURCE_EXTNS.SOURCE_EMAIL%TYPE;

86:
87: l_resource_id number;
88: l_first_name JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE;
89: l_last_name JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE;
90: l_email_id JTF_RS_RESOURCE_EXTNS.SOURCE_EMAIL%TYPE;
91: l_full_name Varchar2(360);
92:
93: l_quoteSourceSatusId Number := null;
94: l_quoteDestStatusId Number := null;

Line 106: From JTF_RS_RESOURCE_EXTNS

102: and user_name = c_login_name;
103:
104: Cursor C_Name_form_ResourceId(c_resource_id number)IS
105: Select SOURCE_FIRST_NAME, SOURCE_LAST_NAME, SOURCE_EMAIL
106: From JTF_RS_RESOURCE_EXTNS
107: Where RESOURCE_ID = c_resource_id;
108:
109: l_debug VARCHAR2(1);
110:

Line 464: l_first_name JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE;

460: l_messageName WF_MESSAGES.NAME%TYPE;
461: l_msgEnabled VARCHAR2(3) :='Y';
462:
463: l_resource_id number;
464: l_first_name JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE;
465: l_last_name JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE;
466: l_email_id JTF_RS_RESOURCE_EXTNS.SOURCE_EMAIL%TYPE;
467: l_full_name Varchar2(360);
468: l_cart_name varchar2(80);

Line 465: l_last_name JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE;

461: l_msgEnabled VARCHAR2(3) :='Y';
462:
463: l_resource_id number;
464: l_first_name JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE;
465: l_last_name JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE;
466: l_email_id JTF_RS_RESOURCE_EXTNS.SOURCE_EMAIL%TYPE;
467: l_full_name Varchar2(360);
468: l_cart_name varchar2(80);
469:

Line 466: l_email_id JTF_RS_RESOURCE_EXTNS.SOURCE_EMAIL%TYPE;

462:
463: l_resource_id number;
464: l_first_name JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE;
465: l_last_name JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE;
466: l_email_id JTF_RS_RESOURCE_EXTNS.SOURCE_EMAIL%TYPE;
467: l_full_name Varchar2(360);
468: l_cart_name varchar2(80);
469:
470: l_quoteSourceSatusId Number := null;

Line 490: From JTF_RS_RESOURCE_EXTNS

486: and user_name = c_login_name;
487:
488: Cursor C_Name_form_ResourceId(c_resource_id number)IS
489: Select SOURCE_FIRST_NAME, SOURCE_LAST_NAME, SOURCE_EMAIL
490: From JTF_RS_RESOURCE_EXTNS
491: Where RESOURCE_ID = c_resource_id;
492:
493: Cursor C_nls_language IS
494: select nls_language from wf_languages