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