DBA Data[Home] [Help]

APPS.PON_TEAM_SCORING_UTIL_PVT dependencies on FND_GLOBAL

Line 64: ,last_updated_by = fnd_global.user_id

60: UPDATE pon_auction_headers_all
61: SET scoring_lock_date = SYSDATE
62: ,scoring_lock_tp_contact_id = p_tpc_id
63: ,last_update_date = SYSDATE
64: ,last_updated_by = fnd_global.user_id
65: WHERE auction_header_id = p_auction_header_id
66: AND scoring_lock_date IS NULL;
67:
68: IF SQL%NOTFOUND THEN

Line 84: ,fnd_global.user_id created_by

80: ,paa.attribute_name
81: ,paa.datatype
82: ,null value
83: ,SYSDATE creation_date
84: ,fnd_global.user_id created_by
85: ,SYSDATE last_update_date
86: ,fnd_global.user_id updated_by
87: ,AVG(ptmas.score) score
88: ,ptmas.attribute_sequence_number

Line 86: ,fnd_global.user_id updated_by

82: ,null value
83: ,SYSDATE creation_date
84: ,fnd_global.user_id created_by
85: ,SYSDATE last_update_date
86: ,fnd_global.user_id updated_by
87: ,AVG(ptmas.score) score
88: ,ptmas.attribute_sequence_number
89: ,paa.attr_level
90: ,paa.attr_max_score

Line 128: ,fnd_global.user_id

124: ,ptmas.attribute_sequence_number
125: ,paa.attribute_name
126: ,paa.datatype
127: ,SYSDATE
128: ,fnd_global.user_id
129: ,SYSDATE
130: ,fnd_global.user_id
131: ,paa.attr_level
132: ,paa.attr_max_score

Line 130: ,fnd_global.user_id

126: ,paa.datatype
127: ,SYSDATE
128: ,fnd_global.user_id
129: ,SYSDATE
130: ,fnd_global.user_id
131: ,paa.attr_level
132: ,paa.attr_max_score
133: ,paa.weight
134: ,paa.attr_group_seq_number

Line 181: ,fnd_global.user_id -- created_by

177: ,ptmavg.attribute_name
178: ,ptmavg.datatype
179: ,null
180: ,SYSDATE -- creation_date
181: ,fnd_global.user_id -- created_by
182: ,SYSDATE -- last_update_date
183: ,fnd_global.user_id -- updated_by
184: ,ptmavg.score -- Calculated member Average Score
185: ,ptmavg.attribute_sequence_number

Line 183: ,fnd_global.user_id -- updated_by

179: ,null
180: ,SYSDATE -- creation_date
181: ,fnd_global.user_id -- created_by
182: ,SYSDATE -- last_update_date
183: ,fnd_global.user_id -- updated_by
184: ,ptmavg.score -- Calculated member Average Score
185: ,ptmavg.attribute_sequence_number
186: ,ptmavg.attr_level
187: ,((ptmavg.score*ptmavg.weight)/NVL(ptmavg.attr_max_score, 0)) -- calculated weighted score

Line 668: ,last_updated_by = fnd_global.user_id

664: UPDATE pon_auction_headers_all
665: SET scoring_lock_date = null
666: ,scoring_lock_tp_contact_id = p_tpc_id
667: ,last_update_date = SYSDATE
668: ,last_updated_by = fnd_global.user_id
669: WHERE auction_header_id = p_auction_header_id
670: AND scoring_lock_date IS NOT NULL;
671:
672: IF SQL%NOTFOUND THEN

Line 686: ,last_updated_by = fnd_global.user_id

682: SET score = NULL
683: ,internal_note = NULL
684: ,weighted_score = NULL
685: ,last_update_date = SYSDATE
686: ,last_updated_by = fnd_global.user_id
687: WHERE auction_header_id = p_auction_header_id
688: AND line_number = -1
689: AND sequence_number IN
690: (SELECT paa.sequence_number

Line 712: ,last_updated_by = fnd_global.user_id

708: SET score_overriden_flag = NULL
709: ,score_overriden_date = NULL
710: ,score_override_tp_contact_id = NULL
711: ,last_update_date = SYSDATE
712: ,last_updated_by = fnd_global.user_id
713: WHERE auction_header_id = p_auction_header_id;
714:
715: x_return_status := fnd_api.G_RET_STS_SUCCESS;
716: