132: END IF;
133:
134: l_drop_ship_tbl := p_drop_ship_tbl;
135:
136: -- l_user_id := FND_GLOBAL.USER_ID; -- Commented for bug 6118936
137: l_login_id := FND_GLOBAL.LOGIN_ID;
138: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
139: -- l_application_id := FND_GLOBAL.RESP_APPL_ID; -- Commented for bug 6118936
140: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
133:
134: l_drop_ship_tbl := p_drop_ship_tbl;
135:
136: -- l_user_id := FND_GLOBAL.USER_ID; -- Commented for bug 6118936
137: l_login_id := FND_GLOBAL.LOGIN_ID;
138: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
139: -- l_application_id := FND_GLOBAL.RESP_APPL_ID; -- Commented for bug 6118936
140: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
141: -- l_resp_id := FND_GLOBAL.RESP_ID; -- Commented for bug 6118936
134: l_drop_ship_tbl := p_drop_ship_tbl;
135:
136: -- l_user_id := FND_GLOBAL.USER_ID; -- Commented for bug 6118936
137: l_login_id := FND_GLOBAL.LOGIN_ID;
138: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
139: -- l_application_id := FND_GLOBAL.RESP_APPL_ID; -- Commented for bug 6118936
140: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
141: -- l_resp_id := FND_GLOBAL.RESP_ID; -- Commented for bug 6118936
142: -- This change is required since we are dropping the profile OE_ORGANIZATION -- _ID. Change made by Esha.
135:
136: -- l_user_id := FND_GLOBAL.USER_ID; -- Commented for bug 6118936
137: l_login_id := FND_GLOBAL.LOGIN_ID;
138: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
139: -- l_application_id := FND_GLOBAL.RESP_APPL_ID; -- Commented for bug 6118936
140: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
141: -- l_resp_id := FND_GLOBAL.RESP_ID; -- Commented for bug 6118936
142: -- This change is required since we are dropping the profile OE_ORGANIZATION -- _ID. Change made by Esha.
143: l_org_id2 := FND_PROFILE.VALUE('OE_ORGANIZATION_ID');
136: -- l_user_id := FND_GLOBAL.USER_ID; -- Commented for bug 6118936
137: l_login_id := FND_GLOBAL.LOGIN_ID;
138: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
139: -- l_application_id := FND_GLOBAL.RESP_APPL_ID; -- Commented for bug 6118936
140: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
141: -- l_resp_id := FND_GLOBAL.RESP_ID; -- Commented for bug 6118936
142: -- This change is required since we are dropping the profile OE_ORGANIZATION -- _ID. Change made by Esha.
143: l_org_id2 := FND_PROFILE.VALUE('OE_ORGANIZATION_ID');
144: l_org_id := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
137: l_login_id := FND_GLOBAL.LOGIN_ID;
138: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
139: -- l_application_id := FND_GLOBAL.RESP_APPL_ID; -- Commented for bug 6118936
140: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
141: -- l_resp_id := FND_GLOBAL.RESP_ID; -- Commented for bug 6118936
142: -- This change is required since we are dropping the profile OE_ORGANIZATION -- _ID. Change made by Esha.
143: l_org_id2 := FND_PROFILE.VALUE('OE_ORGANIZATION_ID');
144: l_org_id := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
145: