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 447: l_first_name JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE;

443: l_messageName WF_MESSAGES.NAME%TYPE;
444: l_msgEnabled VARCHAR2(3) :='Y';
445:
446: l_resource_id number;
447: l_first_name JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE;
448: l_last_name JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE;
449: l_email_id JTF_RS_RESOURCE_EXTNS.SOURCE_EMAIL%TYPE;
450: l_full_name Varchar2(360);
451: l_cart_name varchar2(80);

Line 448: l_last_name JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE;

444: l_msgEnabled VARCHAR2(3) :='Y';
445:
446: l_resource_id number;
447: l_first_name JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE;
448: l_last_name JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE;
449: l_email_id JTF_RS_RESOURCE_EXTNS.SOURCE_EMAIL%TYPE;
450: l_full_name Varchar2(360);
451: l_cart_name varchar2(80);
452:

Line 449: l_email_id JTF_RS_RESOURCE_EXTNS.SOURCE_EMAIL%TYPE;

445:
446: l_resource_id number;
447: l_first_name JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE;
448: l_last_name JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE;
449: l_email_id JTF_RS_RESOURCE_EXTNS.SOURCE_EMAIL%TYPE;
450: l_full_name Varchar2(360);
451: l_cart_name varchar2(80);
452:
453: l_quoteSourceSatusId Number := null;

Line 473: From JTF_RS_RESOURCE_EXTNS

469: and user_name = c_login_name;
470:
471: Cursor C_Name_form_ResourceId(c_resource_id number)IS
472: Select SOURCE_FIRST_NAME, SOURCE_LAST_NAME, SOURCE_EMAIL
473: From JTF_RS_RESOURCE_EXTNS
474: Where RESOURCE_ID = c_resource_id;
475:
476: Cursor C_nls_language IS
477: select nls_language from wf_languages