DBA Data[Home] [Help]

APPS.PNT_PAYMENT_TERMS_PKG dependencies on FND_GLOBAL

Line 2039: ,FND_GLOBAL.USER_ID

2035: VALUES
2036: (
2037: pn_distributions_history_s.NEXTVAL
2038: ,SYSDATE
2039: ,FND_GLOBAL.USER_ID
2040: ,SYSDATE
2041: ,FND_GLOBAL.USER_ID
2042: ,FND_GLOBAL.LOGIN_ID
2043: ,l_dist_change_id

Line 2041: ,FND_GLOBAL.USER_ID

2037: pn_distributions_history_s.NEXTVAL
2038: ,SYSDATE
2039: ,FND_GLOBAL.USER_ID
2040: ,SYSDATE
2041: ,FND_GLOBAL.USER_ID
2042: ,FND_GLOBAL.LOGIN_ID
2043: ,l_dist_change_id
2044: ,p_hist_dist_tab(i).DISTRIBUTION_ID
2045: ,p_hist_dist_tab(i).ACCOUNT_ID

Line 2042: ,FND_GLOBAL.LOGIN_ID

2038: ,SYSDATE
2039: ,FND_GLOBAL.USER_ID
2040: ,SYSDATE
2041: ,FND_GLOBAL.USER_ID
2042: ,FND_GLOBAL.LOGIN_ID
2043: ,l_dist_change_id
2044: ,p_hist_dist_tab(i).DISTRIBUTION_ID
2045: ,p_hist_dist_tab(i).ACCOUNT_ID
2046: ,p_hist_dist_tab(i).ACCOUNT_CLASS

Line 2178: ,FND_GLOBAL.USER_ID

2174: ,TERM_COMMENTS)
2175: VALUES
2176: (PN_PAYMENT_TERMS_HISTORY_S.NEXTVAL
2177: ,SYSDATE
2178: ,FND_GLOBAL.USER_ID
2179: ,SYSDATE
2180: ,FND_GLOBAL.USER_ID
2181: ,FND_GLOBAL.LOGIN_ID
2182: ,tlinfo.PAYMENT_TERM_ID

Line 2180: ,FND_GLOBAL.USER_ID

2176: (PN_PAYMENT_TERMS_HISTORY_S.NEXTVAL
2177: ,SYSDATE
2178: ,FND_GLOBAL.USER_ID
2179: ,SYSDATE
2180: ,FND_GLOBAL.USER_ID
2181: ,FND_GLOBAL.LOGIN_ID
2182: ,tlinfo.PAYMENT_TERM_ID
2183: ,l_dist_change_id
2184: ,NULL -- PREV_TERM_HISTORY_ID

Line 2181: ,FND_GLOBAL.LOGIN_ID

2177: ,SYSDATE
2178: ,FND_GLOBAL.USER_ID
2179: ,SYSDATE
2180: ,FND_GLOBAL.USER_ID
2181: ,FND_GLOBAL.LOGIN_ID
2182: ,tlinfo.PAYMENT_TERM_ID
2183: ,l_dist_change_id
2184: ,NULL -- PREV_TERM_HISTORY_ID
2185: ,NULL -- ADJUSTMENT_TYPE_CODE

Line 2334: ,FND_GLOBAL.USER_ID

2330: VALUES
2331: (
2332: pn_distributions_history_s.NEXTVAL
2333: ,SYSDATE
2334: ,FND_GLOBAL.USER_ID
2335: ,SYSDATE
2336: ,FND_GLOBAL.USER_ID
2337: ,FND_GLOBAL.LOGIN_ID
2338: ,l_dist_change_id

Line 2336: ,FND_GLOBAL.USER_ID

2332: pn_distributions_history_s.NEXTVAL
2333: ,SYSDATE
2334: ,FND_GLOBAL.USER_ID
2335: ,SYSDATE
2336: ,FND_GLOBAL.USER_ID
2337: ,FND_GLOBAL.LOGIN_ID
2338: ,l_dist_change_id
2339: ,dist_rec.DISTRIBUTION_ID
2340: ,dist_rec.ACCOUNT_ID

Line 2337: ,FND_GLOBAL.LOGIN_ID

2333: ,SYSDATE
2334: ,FND_GLOBAL.USER_ID
2335: ,SYSDATE
2336: ,FND_GLOBAL.USER_ID
2337: ,FND_GLOBAL.LOGIN_ID
2338: ,l_dist_change_id
2339: ,dist_rec.DISTRIBUTION_ID
2340: ,dist_rec.ACCOUNT_ID
2341: ,dist_rec.ACCOUNT_CLASS

Line 2523: ,FND_GLOBAL.USER_ID

2519: ,TERM_COMMENTS)
2520: VALUES
2521: (PN_PAYMENT_TERMS_HISTORY_S.NEXTVAL
2522: ,SYSDATE
2523: ,FND_GLOBAL.USER_ID
2524: ,SYSDATE
2525: ,FND_GLOBAL.USER_ID
2526: ,FND_GLOBAL.LOGIN_ID
2527: ,tlinfo.payment_term_id

Line 2525: ,FND_GLOBAL.USER_ID

2521: (PN_PAYMENT_TERMS_HISTORY_S.NEXTVAL
2522: ,SYSDATE
2523: ,FND_GLOBAL.USER_ID
2524: ,SYSDATE
2525: ,FND_GLOBAL.USER_ID
2526: ,FND_GLOBAL.LOGIN_ID
2527: ,tlinfo.payment_term_id
2528: ,l_dist_change_id
2529: ,l_prev_term_hist_id

Line 2526: ,FND_GLOBAL.LOGIN_ID

2522: ,SYSDATE
2523: ,FND_GLOBAL.USER_ID
2524: ,SYSDATE
2525: ,FND_GLOBAL.USER_ID
2526: ,FND_GLOBAL.LOGIN_ID
2527: ,tlinfo.payment_term_id
2528: ,l_dist_change_id
2529: ,l_prev_term_hist_id
2530: ,l_adj_type_code

Line 2708: ,FND_GLOBAL.USER_ID

2704: ,ATTRIBUTE15)
2705: VALUES
2706: (pn_distributions_history_s.NEXTVAL
2707: ,SYSDATE
2708: ,FND_GLOBAL.USER_ID
2709: ,SYSDATE
2710: ,FND_GLOBAL.USER_ID
2711: ,FND_GLOBAL.LOGIN_ID
2712: ,l_dist_change_id

Line 2710: ,FND_GLOBAL.USER_ID

2706: (pn_distributions_history_s.NEXTVAL
2707: ,SYSDATE
2708: ,FND_GLOBAL.USER_ID
2709: ,SYSDATE
2710: ,FND_GLOBAL.USER_ID
2711: ,FND_GLOBAL.LOGIN_ID
2712: ,l_dist_change_id
2713: ,l_new_dist_id
2714: ,dist_rec.ACCOUNT_ID

Line 2711: ,FND_GLOBAL.LOGIN_ID

2707: ,SYSDATE
2708: ,FND_GLOBAL.USER_ID
2709: ,SYSDATE
2710: ,FND_GLOBAL.USER_ID
2711: ,FND_GLOBAL.LOGIN_ID
2712: ,l_dist_change_id
2713: ,l_new_dist_id
2714: ,dist_rec.ACCOUNT_ID
2715: ,dist_rec.ACCOUNT_CLASS

Line 2870: ,FND_GLOBAL.USER_ID

2866: ,TERM_COMMENTS)
2867: VALUES
2868: (PN_PAYMENT_TERMS_HISTORY_S.NEXTVAL
2869: ,SYSDATE
2870: ,FND_GLOBAL.USER_ID
2871: ,SYSDATE
2872: ,FND_GLOBAL.USER_ID
2873: ,FND_GLOBAL.LOGIN_ID
2874: ,l_new_term_id

Line 2872: ,FND_GLOBAL.USER_ID

2868: (PN_PAYMENT_TERMS_HISTORY_S.NEXTVAL
2869: ,SYSDATE
2870: ,FND_GLOBAL.USER_ID
2871: ,SYSDATE
2872: ,FND_GLOBAL.USER_ID
2873: ,FND_GLOBAL.LOGIN_ID
2874: ,l_new_term_id
2875: ,l_dist_change_id
2876: ,l_prev_term_hist_id

Line 2873: ,FND_GLOBAL.LOGIN_ID

2869: ,SYSDATE
2870: ,FND_GLOBAL.USER_ID
2871: ,SYSDATE
2872: ,FND_GLOBAL.USER_ID
2873: ,FND_GLOBAL.LOGIN_ID
2874: ,l_new_term_id
2875: ,l_dist_change_id
2876: ,l_prev_term_hist_id
2877: ,l_adj_type_code

Line 3001: l_last_updated_by := FND_GLOBAL.USER_ID;

2997: l_end_dt := p_eff_str_dt - 1;
2998: l_adj_type_code := 'ADJ-PCON';
2999: l_term_comments := term_rec.term_comments;
3000: l_last_update_date := SYSDATE;
3001: l_last_updated_by := FND_GLOBAL.USER_ID;
3002: l_creation_date := tlinfo.creation_date;
3003: l_created_by := tlinfo.created_by;
3004: l_last_update_login := FND_GLOBAL.LOGIN_ID;
3005: l_changed_flag := 'Y';

Line 3004: l_last_update_login := FND_GLOBAL.LOGIN_ID;

3000: l_last_update_date := SYSDATE;
3001: l_last_updated_by := FND_GLOBAL.USER_ID;
3002: l_creation_date := tlinfo.creation_date;
3003: l_created_by := tlinfo.created_by;
3004: l_last_update_login := FND_GLOBAL.LOGIN_ID;
3005: l_changed_flag := 'Y';
3006:
3007: ELSIF (p_eff_str_dt <> term_rec.start_date AND
3008: i = 2) OR

Line 3021: l_last_updated_by := FND_GLOBAL.USER_ID;

3017: l_end_dt := term_rec.end_date;
3018: l_adj_type_code := NULL;
3019: l_term_comments := NULL;
3020: l_last_update_date := SYSDATE;
3021: l_last_updated_by := FND_GLOBAL.USER_ID;
3022: l_creation_date := SYSDATE;
3023: l_created_by := FND_GLOBAL.USER_ID;
3024: l_last_update_login := FND_GLOBAL.LOGIN_ID;
3025: l_changed_flag := 'N';

Line 3023: l_created_by := FND_GLOBAL.USER_ID;

3019: l_term_comments := NULL;
3020: l_last_update_date := SYSDATE;
3021: l_last_updated_by := FND_GLOBAL.USER_ID;
3022: l_creation_date := SYSDATE;
3023: l_created_by := FND_GLOBAL.USER_ID;
3024: l_last_update_login := FND_GLOBAL.LOGIN_ID;
3025: l_changed_flag := 'N';
3026:
3027: END IF;

Line 3024: l_last_update_login := FND_GLOBAL.LOGIN_ID;

3020: l_last_update_date := SYSDATE;
3021: l_last_updated_by := FND_GLOBAL.USER_ID;
3022: l_creation_date := SYSDATE;
3023: l_created_by := FND_GLOBAL.USER_ID;
3024: l_last_update_login := FND_GLOBAL.LOGIN_ID;
3025: l_changed_flag := 'N';
3026:
3027: END IF;
3028:

Line 3365: ,FND_GLOBAL.USER_ID

3361: ,ATTRIBUTE15)
3362: VALUES
3363: (pn_distributions_history_s.NEXTVAL
3364: ,SYSDATE
3365: ,FND_GLOBAL.USER_ID
3366: ,SYSDATE
3367: ,FND_GLOBAL.USER_ID
3368: ,FND_GLOBAL.LOGIN_ID
3369: ,l_dist_change_id

Line 3367: ,FND_GLOBAL.USER_ID

3363: (pn_distributions_history_s.NEXTVAL
3364: ,SYSDATE
3365: ,FND_GLOBAL.USER_ID
3366: ,SYSDATE
3367: ,FND_GLOBAL.USER_ID
3368: ,FND_GLOBAL.LOGIN_ID
3369: ,l_dist_change_id
3370: ,l_dist_id
3371: ,p_hist_dist_tab(j).ACCOUNT_ID

Line 3368: ,FND_GLOBAL.LOGIN_ID

3364: ,SYSDATE
3365: ,FND_GLOBAL.USER_ID
3366: ,SYSDATE
3367: ,FND_GLOBAL.USER_ID
3368: ,FND_GLOBAL.LOGIN_ID
3369: ,l_dist_change_id
3370: ,l_dist_id
3371: ,p_hist_dist_tab(j).ACCOUNT_ID
3372: ,p_hist_dist_tab(j).ACCOUNT_CLASS

Line 3513: ,FND_GLOBAL.USER_ID

3509: ,TERM_COMMENTS)
3510: VALUES
3511: (PN_PAYMENT_TERMS_HISTORY_S.NEXTVAL
3512: ,SYSDATE
3513: ,FND_GLOBAL.USER_ID
3514: ,SYSDATE
3515: ,FND_GLOBAL.USER_ID
3516: ,FND_GLOBAL.LOGIN_ID
3517: ,l_term_id

Line 3515: ,FND_GLOBAL.USER_ID

3511: (PN_PAYMENT_TERMS_HISTORY_S.NEXTVAL
3512: ,SYSDATE
3513: ,FND_GLOBAL.USER_ID
3514: ,SYSDATE
3515: ,FND_GLOBAL.USER_ID
3516: ,FND_GLOBAL.LOGIN_ID
3517: ,l_term_id
3518: ,l_dist_change_id
3519: ,l_prev_term_hist_id

Line 3516: ,FND_GLOBAL.LOGIN_ID

3512: ,SYSDATE
3513: ,FND_GLOBAL.USER_ID
3514: ,SYSDATE
3515: ,FND_GLOBAL.USER_ID
3516: ,FND_GLOBAL.LOGIN_ID
3517: ,l_term_id
3518: ,l_dist_change_id
3519: ,l_prev_term_hist_id
3520: ,l_adj_type_code