929: VALUES
930: (x_instr_id,
931: x_transaction_id,
932: sysdate,
933: fnd_global.user_id,
934: fnd_global.user_id,
935: sysdate,
936: fnd_global.login_id
937: );
930: (x_instr_id,
931: x_transaction_id,
932: sysdate,
933: fnd_global.user_id,
934: fnd_global.user_id,
935: sysdate,
936: fnd_global.login_id
937: );
938: END IF;
932: sysdate,
933: fnd_global.user_id,
934: fnd_global.user_id,
935: sysdate,
936: fnd_global.login_id
937: );
938: END IF;
939: x_txn_id := x_transaction_id;
940: IF (fnd_api.to_boolean(p_commit))
1452: INTO l_contact_point_id,l_contact_party_id
1453: FROM hz_contact_points contacts,hz_parties parties,fnd_user usr
1454: WHERE contacts.owner_table_name = 'HZ_PARTIES'
1455: AND contacts.email_address = p_email
1456: AND usr.user_id = fnd_global.user_id
1457: AND parties.party_id = usr.customer_id
1458: AND contacts.owner_table_id = parties.party_id
1459: AND contacts.status = 'A'
1460: AND ROWNUM < 2;
1468: ELSE
1469: SELECT customer_id
1470: INTO l_contact_party_id
1471: FROM fnd_user
1472: WHERE user_id = fnd_global.user_id;
1473: END IF;
1474: END;
1475:
1476: IF l_create_contact
1513: ELSE
1514: SELECT party.party_type,party.party_id
1515: INTO l_service_request_rec.contact_type,l_service_request_rec.party_id
1516: FROM hz_parties party,fnd_user usr
1517: WHERE usr.user_id = fnd_global.user_id
1518: AND usr.customer_id = party.party_id;
1519: END IF;
1520: ELSE
1521: l_service_request_rec.party_id := null;
2097: l_estimate_lines_rec.return_reason := NULL; --p_ret_reasons(i);
2098: l_estimate_lines_rec.return_by_date := SYSDATE;
2099: l_estimate_lines_rec.last_update_date := SYSDATE;
2100: l_estimate_lines_rec.creation_date := SYSDATE;
2101: l_estimate_lines_rec.last_updated_by := fnd_global.user_id;
2102: l_estimate_lines_rec.created_by := fnd_global.user_id;
2103: l_estimate_lines_rec.last_update_login := fnd_global.login_id;
2104: l_estimate_lines_rec.attribute1 := null;
2105: l_estimate_lines_rec.attribute2 := null;
2098: l_estimate_lines_rec.return_by_date := SYSDATE;
2099: l_estimate_lines_rec.last_update_date := SYSDATE;
2100: l_estimate_lines_rec.creation_date := SYSDATE;
2101: l_estimate_lines_rec.last_updated_by := fnd_global.user_id;
2102: l_estimate_lines_rec.created_by := fnd_global.user_id;
2103: l_estimate_lines_rec.last_update_login := fnd_global.login_id;
2104: l_estimate_lines_rec.attribute1 := null;
2105: l_estimate_lines_rec.attribute2 := null;
2106: l_estimate_lines_rec.attribute3 := null;
2099: l_estimate_lines_rec.last_update_date := SYSDATE;
2100: l_estimate_lines_rec.creation_date := SYSDATE;
2101: l_estimate_lines_rec.last_updated_by := fnd_global.user_id;
2102: l_estimate_lines_rec.created_by := fnd_global.user_id;
2103: l_estimate_lines_rec.last_update_login := fnd_global.login_id;
2104: l_estimate_lines_rec.attribute1 := null;
2105: l_estimate_lines_rec.attribute2 := null;
2106: l_estimate_lines_rec.attribute3 := null;
2107: l_estimate_lines_rec.attribute4 := null;