eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ASO_CONC_REQ_INT dependencies on FND_GLOBAL

Line 36: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

32: l_DEFAULTING_FWK_FLAG VARCHAR2(1);
33: l_APPLICATION_TYPE_CODE VARCHAR2(30);
34: l_pricing_status_indicator VARCHAR2(11);
35: l_tax_status_indicator VARCHAR2(11);
36: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
37: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
38: x_status VARCHAR2(1);
39: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type:=ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
40: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_Miss_Control_Rec;

Line 37: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

33: l_APPLICATION_TYPE_CODE VARCHAR2(30);
34: l_pricing_status_indicator VARCHAR2(11);
35: l_tax_status_indicator VARCHAR2(11);
36: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
37: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
38: x_status VARCHAR2(1);
39: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type:=ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
40: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_Miss_Control_Rec;
41: l_hd_Price_Attributes_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

Line 878: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

874: ********************************************************/
875:
876: procedure Update_price_req_id(p_quote_header_id IN Number) is
877:
878: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
879: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
880: l_last_update_date Date := SYSDATE;
881:
882: Begin

Line 879: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

875:
876: procedure Update_price_req_id(p_quote_header_id IN Number) is
877:
878: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
879: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
880: l_last_update_date Date := SYSDATE;
881:
882: Begin
883:

Line 906: l_user_id Number := FND_GLOBAL.USER_ID;

902:
903: wf_itemkey_seq INTEGER;
904: wf_itemkey VARCHAR2(30);
905: lx_wf_role VARCHAR2(30);
906: l_user_id Number := FND_GLOBAL.USER_ID;
907: lx_notification_preference VARCHAR2(30);
908: lx_document VARCHAR2(2000);
909: lx_document_type VARCHAR2(2000);
910: l_qte_number number;

Line 1065: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotFrmDspFile=qotSCocOverview.jsp';

1061:
1062: -- get the jsp name
1063: l_jsp_name := 'qotSZzpAppsLink.jsp?';
1064: l_jsp_name := l_jsp_name || 'qotFrmMainFile=qotSZzdContainer.jsp';
1065: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotFrmDspFile=qotSCocOverview.jsp';
1066: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotFrmRefFile=qotSCocOverview.jsp';
1067: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotDetCode=QUOTE';
1068: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotPtyType='|| l_party_type;
1069: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotHdrId='|| p_quote_header_id;

Line 1066: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotFrmRefFile=qotSCocOverview.jsp';

1062: -- get the jsp name
1063: l_jsp_name := 'qotSZzpAppsLink.jsp?';
1064: l_jsp_name := l_jsp_name || 'qotFrmMainFile=qotSZzdContainer.jsp';
1065: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotFrmDspFile=qotSCocOverview.jsp';
1066: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotFrmRefFile=qotSCocOverview.jsp';
1067: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotDetCode=QUOTE';
1068: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotPtyType='|| l_party_type;
1069: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotHdrId='|| p_quote_header_id;
1070: if l_party_number is not null then

Line 1067: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotDetCode=QUOTE';

1063: l_jsp_name := 'qotSZzpAppsLink.jsp?';
1064: l_jsp_name := l_jsp_name || 'qotFrmMainFile=qotSZzdContainer.jsp';
1065: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotFrmDspFile=qotSCocOverview.jsp';
1066: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotFrmRefFile=qotSCocOverview.jsp';
1067: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotDetCode=QUOTE';
1068: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotPtyType='|| l_party_type;
1069: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotHdrId='|| p_quote_header_id;
1070: if l_party_number is not null then
1071: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotHdrAcctId='||l_party_number;

Line 1068: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotPtyType='|| l_party_type;

1064: l_jsp_name := l_jsp_name || 'qotFrmMainFile=qotSZzdContainer.jsp';
1065: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotFrmDspFile=qotSCocOverview.jsp';
1066: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotFrmRefFile=qotSCocOverview.jsp';
1067: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotDetCode=QUOTE';
1068: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotPtyType='|| l_party_type;
1069: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotHdrId='|| p_quote_header_id;
1070: if l_party_number is not null then
1071: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotHdrAcctId='||l_party_number;
1072: end if;

Line 1069: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotHdrId='|| p_quote_header_id;

1065: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotFrmDspFile=qotSCocOverview.jsp';
1066: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotFrmRefFile=qotSCocOverview.jsp';
1067: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotDetCode=QUOTE';
1068: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotPtyType='|| l_party_type;
1069: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotHdrId='|| p_quote_header_id;
1070: if l_party_number is not null then
1071: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotHdrAcctId='||l_party_number;
1072: end if;
1073: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotHdrNbr='|| l_quote_number;

Line 1071: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotHdrAcctId='||l_party_number;

1067: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotDetCode=QUOTE';
1068: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotPtyType='|| l_party_type;
1069: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotHdrId='|| p_quote_header_id;
1070: if l_party_number is not null then
1071: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotHdrAcctId='||l_party_number;
1072: end if;
1073: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotHdrNbr='|| l_quote_number;
1074: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotReqSetCookie=Y';
1075: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotFromApvlLink=Y';

Line 1073: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotHdrNbr='|| l_quote_number;

1069: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotHdrId='|| p_quote_header_id;
1070: if l_party_number is not null then
1071: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotHdrAcctId='||l_party_number;
1072: end if;
1073: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotHdrNbr='|| l_quote_number;
1074: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotReqSetCookie=Y';
1075: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotFromApvlLink=Y';
1076:
1077: -- get the attribute label

Line 1074: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotReqSetCookie=Y';

1070: if l_party_number is not null then
1071: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotHdrAcctId='||l_party_number;
1072: end if;
1073: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotHdrNbr='|| l_quote_number;
1074: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotReqSetCookie=Y';
1075: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotFromApvlLink=Y';
1076:
1077: -- get the attribute label
1078: Begin

Line 1075: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotFromApvlLink=Y';

1071: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotHdrAcctId='||l_party_number;
1072: end if;
1073: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotHdrNbr='|| l_quote_number;
1074: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotReqSetCookie=Y';
1075: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotFromApvlLink=Y';
1076:
1077: -- get the attribute label
1078: Begin
1079: fnd_message.set_name('ASO','ASO_QUOTE_DETAILS_URL');

Line 1190: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotFrmDspFile=qotSCocOverview.jsp';

1186:
1187: -- get the jsp name
1188: l_jsp_name := 'qotSZzpAppsLink.jsp?';
1189: l_jsp_name := l_jsp_name || 'qotFrmMainFile=qotSZzdContainer.jsp';
1190: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotFrmDspFile=qotSCocOverview.jsp';
1191: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotFrmRefFile=qotSCocOverview.jsp';
1192: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotDetCode=QUOTE';
1193: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotPtyType='|| l_party_type;
1194: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotHdrId='|| l_quote_header_id;

Line 1191: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotFrmRefFile=qotSCocOverview.jsp';

1187: -- get the jsp name
1188: l_jsp_name := 'qotSZzpAppsLink.jsp?';
1189: l_jsp_name := l_jsp_name || 'qotFrmMainFile=qotSZzdContainer.jsp';
1190: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotFrmDspFile=qotSCocOverview.jsp';
1191: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotFrmRefFile=qotSCocOverview.jsp';
1192: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotDetCode=QUOTE';
1193: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotPtyType='|| l_party_type;
1194: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotHdrId='|| l_quote_header_id;
1195: if l_party_number is not null then

Line 1192: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotDetCode=QUOTE';

1188: l_jsp_name := 'qotSZzpAppsLink.jsp?';
1189: l_jsp_name := l_jsp_name || 'qotFrmMainFile=qotSZzdContainer.jsp';
1190: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotFrmDspFile=qotSCocOverview.jsp';
1191: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotFrmRefFile=qotSCocOverview.jsp';
1192: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotDetCode=QUOTE';
1193: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotPtyType='|| l_party_type;
1194: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotHdrId='|| l_quote_header_id;
1195: if l_party_number is not null then
1196: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotHdrAcctId='||l_party_number;

Line 1193: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotPtyType='|| l_party_type;

1189: l_jsp_name := l_jsp_name || 'qotFrmMainFile=qotSZzdContainer.jsp';
1190: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotFrmDspFile=qotSCocOverview.jsp';
1191: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotFrmRefFile=qotSCocOverview.jsp';
1192: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotDetCode=QUOTE';
1193: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotPtyType='|| l_party_type;
1194: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotHdrId='|| l_quote_header_id;
1195: if l_party_number is not null then
1196: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotHdrAcctId='||l_party_number;
1197: end if;

Line 1194: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotHdrId='|| l_quote_header_id;

1190: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotFrmDspFile=qotSCocOverview.jsp';
1191: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotFrmRefFile=qotSCocOverview.jsp';
1192: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotDetCode=QUOTE';
1193: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotPtyType='|| l_party_type;
1194: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotHdrId='|| l_quote_header_id;
1195: if l_party_number is not null then
1196: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotHdrAcctId='||l_party_number;
1197: end if;
1198: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotHdrNbr='|| l_quote_number;

Line 1196: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotHdrAcctId='||l_party_number;

1192: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotDetCode=QUOTE';
1193: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotPtyType='|| l_party_type;
1194: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotHdrId='|| l_quote_header_id;
1195: if l_party_number is not null then
1196: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotHdrAcctId='||l_party_number;
1197: end if;
1198: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotHdrNbr='|| l_quote_number;
1199: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotReqSetCookie=Y';
1200: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotFromApvlLink=Y';

Line 1198: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotHdrNbr='|| l_quote_number;

1194: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotHdrId='|| l_quote_header_id;
1195: if l_party_number is not null then
1196: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotHdrAcctId='||l_party_number;
1197: end if;
1198: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotHdrNbr='|| l_quote_number;
1199: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotReqSetCookie=Y';
1200: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotFromApvlLink=Y';
1201: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotApvOrgId='|| l_org_id;
1202: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotApvNotifId=&#NID';

Line 1199: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotReqSetCookie=Y';

1195: if l_party_number is not null then
1196: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotHdrAcctId='||l_party_number;
1197: end if;
1198: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotHdrNbr='|| l_quote_number;
1199: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotReqSetCookie=Y';
1200: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotFromApvlLink=Y';
1201: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotApvOrgId='|| l_org_id;
1202: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotApvNotifId=&#NID';
1203:

Line 1200: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotFromApvlLink=Y';

1196: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotHdrAcctId='||l_party_number;
1197: end if;
1198: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotHdrNbr='|| l_quote_number;
1199: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotReqSetCookie=Y';
1200: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotFromApvlLink=Y';
1201: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotApvOrgId='|| l_org_id;
1202: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotApvNotifId=&#NID';
1203:
1204: -- get the attribute label

Line 1201: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotApvOrgId='|| l_org_id;

1197: end if;
1198: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotHdrNbr='|| l_quote_number;
1199: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotReqSetCookie=Y';
1200: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotFromApvlLink=Y';
1201: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotApvOrgId='|| l_org_id;
1202: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotApvNotifId=&#NID';
1203:
1204: -- get the attribute label
1205: Begin

Line 1202: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotApvNotifId=&#NID';

1198: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotHdrNbr='|| l_quote_number;
1199: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotReqSetCookie=Y';
1200: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotFromApvlLink=Y';
1201: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotApvOrgId='|| l_org_id;
1202: l_jsp_name := l_jsp_name|| fnd_global.local_chr (38)|| 'qotApvNotifId=&#NID';
1203:
1204: -- get the attribute label
1205: Begin
1206: fnd_message.set_name('ASO','ASO_QUOTE_DETAILS_URL');