DBA Data[Home] [Help]

APPS.PNT_PAYMENT_TERMS_PKG dependencies on FND_GLOBAL

Line 2035: ,FND_GLOBAL.USER_ID

2031: VALUES
2032: (
2033: pn_distributions_history_s.NEXTVAL
2034: ,SYSDATE
2035: ,FND_GLOBAL.USER_ID
2036: ,SYSDATE
2037: ,FND_GLOBAL.USER_ID
2038: ,FND_GLOBAL.LOGIN_ID
2039: ,l_dist_change_id

Line 2037: ,FND_GLOBAL.USER_ID

2033: pn_distributions_history_s.NEXTVAL
2034: ,SYSDATE
2035: ,FND_GLOBAL.USER_ID
2036: ,SYSDATE
2037: ,FND_GLOBAL.USER_ID
2038: ,FND_GLOBAL.LOGIN_ID
2039: ,l_dist_change_id
2040: ,p_hist_dist_tab(i).DISTRIBUTION_ID
2041: ,p_hist_dist_tab(i).ACCOUNT_ID

Line 2038: ,FND_GLOBAL.LOGIN_ID

2034: ,SYSDATE
2035: ,FND_GLOBAL.USER_ID
2036: ,SYSDATE
2037: ,FND_GLOBAL.USER_ID
2038: ,FND_GLOBAL.LOGIN_ID
2039: ,l_dist_change_id
2040: ,p_hist_dist_tab(i).DISTRIBUTION_ID
2041: ,p_hist_dist_tab(i).ACCOUNT_ID
2042: ,p_hist_dist_tab(i).ACCOUNT_CLASS

Line 2174: ,FND_GLOBAL.USER_ID

2170: ,TERM_COMMENTS)
2171: VALUES
2172: (PN_PAYMENT_TERMS_HISTORY_S.NEXTVAL
2173: ,SYSDATE
2174: ,FND_GLOBAL.USER_ID
2175: ,SYSDATE
2176: ,FND_GLOBAL.USER_ID
2177: ,FND_GLOBAL.LOGIN_ID
2178: ,tlinfo.PAYMENT_TERM_ID

Line 2176: ,FND_GLOBAL.USER_ID

2172: (PN_PAYMENT_TERMS_HISTORY_S.NEXTVAL
2173: ,SYSDATE
2174: ,FND_GLOBAL.USER_ID
2175: ,SYSDATE
2176: ,FND_GLOBAL.USER_ID
2177: ,FND_GLOBAL.LOGIN_ID
2178: ,tlinfo.PAYMENT_TERM_ID
2179: ,l_dist_change_id
2180: ,NULL -- PREV_TERM_HISTORY_ID

Line 2177: ,FND_GLOBAL.LOGIN_ID

2173: ,SYSDATE
2174: ,FND_GLOBAL.USER_ID
2175: ,SYSDATE
2176: ,FND_GLOBAL.USER_ID
2177: ,FND_GLOBAL.LOGIN_ID
2178: ,tlinfo.PAYMENT_TERM_ID
2179: ,l_dist_change_id
2180: ,NULL -- PREV_TERM_HISTORY_ID
2181: ,NULL -- ADJUSTMENT_TYPE_CODE

Line 2330: ,FND_GLOBAL.USER_ID

2326: VALUES
2327: (
2328: pn_distributions_history_s.NEXTVAL
2329: ,SYSDATE
2330: ,FND_GLOBAL.USER_ID
2331: ,SYSDATE
2332: ,FND_GLOBAL.USER_ID
2333: ,FND_GLOBAL.LOGIN_ID
2334: ,l_dist_change_id

Line 2332: ,FND_GLOBAL.USER_ID

2328: pn_distributions_history_s.NEXTVAL
2329: ,SYSDATE
2330: ,FND_GLOBAL.USER_ID
2331: ,SYSDATE
2332: ,FND_GLOBAL.USER_ID
2333: ,FND_GLOBAL.LOGIN_ID
2334: ,l_dist_change_id
2335: ,dist_rec.DISTRIBUTION_ID
2336: ,dist_rec.ACCOUNT_ID

Line 2333: ,FND_GLOBAL.LOGIN_ID

2329: ,SYSDATE
2330: ,FND_GLOBAL.USER_ID
2331: ,SYSDATE
2332: ,FND_GLOBAL.USER_ID
2333: ,FND_GLOBAL.LOGIN_ID
2334: ,l_dist_change_id
2335: ,dist_rec.DISTRIBUTION_ID
2336: ,dist_rec.ACCOUNT_ID
2337: ,dist_rec.ACCOUNT_CLASS

Line 2519: ,FND_GLOBAL.USER_ID

2515: ,TERM_COMMENTS)
2516: VALUES
2517: (PN_PAYMENT_TERMS_HISTORY_S.NEXTVAL
2518: ,SYSDATE
2519: ,FND_GLOBAL.USER_ID
2520: ,SYSDATE
2521: ,FND_GLOBAL.USER_ID
2522: ,FND_GLOBAL.LOGIN_ID
2523: ,tlinfo.payment_term_id

Line 2521: ,FND_GLOBAL.USER_ID

2517: (PN_PAYMENT_TERMS_HISTORY_S.NEXTVAL
2518: ,SYSDATE
2519: ,FND_GLOBAL.USER_ID
2520: ,SYSDATE
2521: ,FND_GLOBAL.USER_ID
2522: ,FND_GLOBAL.LOGIN_ID
2523: ,tlinfo.payment_term_id
2524: ,l_dist_change_id
2525: ,l_prev_term_hist_id

Line 2522: ,FND_GLOBAL.LOGIN_ID

2518: ,SYSDATE
2519: ,FND_GLOBAL.USER_ID
2520: ,SYSDATE
2521: ,FND_GLOBAL.USER_ID
2522: ,FND_GLOBAL.LOGIN_ID
2523: ,tlinfo.payment_term_id
2524: ,l_dist_change_id
2525: ,l_prev_term_hist_id
2526: ,l_adj_type_code

Line 2704: ,FND_GLOBAL.USER_ID

2700: ,ATTRIBUTE15)
2701: VALUES
2702: (pn_distributions_history_s.NEXTVAL
2703: ,SYSDATE
2704: ,FND_GLOBAL.USER_ID
2705: ,SYSDATE
2706: ,FND_GLOBAL.USER_ID
2707: ,FND_GLOBAL.LOGIN_ID
2708: ,l_dist_change_id

Line 2706: ,FND_GLOBAL.USER_ID

2702: (pn_distributions_history_s.NEXTVAL
2703: ,SYSDATE
2704: ,FND_GLOBAL.USER_ID
2705: ,SYSDATE
2706: ,FND_GLOBAL.USER_ID
2707: ,FND_GLOBAL.LOGIN_ID
2708: ,l_dist_change_id
2709: ,l_new_dist_id
2710: ,dist_rec.ACCOUNT_ID

Line 2707: ,FND_GLOBAL.LOGIN_ID

2703: ,SYSDATE
2704: ,FND_GLOBAL.USER_ID
2705: ,SYSDATE
2706: ,FND_GLOBAL.USER_ID
2707: ,FND_GLOBAL.LOGIN_ID
2708: ,l_dist_change_id
2709: ,l_new_dist_id
2710: ,dist_rec.ACCOUNT_ID
2711: ,dist_rec.ACCOUNT_CLASS

Line 2866: ,FND_GLOBAL.USER_ID

2862: ,TERM_COMMENTS)
2863: VALUES
2864: (PN_PAYMENT_TERMS_HISTORY_S.NEXTVAL
2865: ,SYSDATE
2866: ,FND_GLOBAL.USER_ID
2867: ,SYSDATE
2868: ,FND_GLOBAL.USER_ID
2869: ,FND_GLOBAL.LOGIN_ID
2870: ,l_new_term_id

Line 2868: ,FND_GLOBAL.USER_ID

2864: (PN_PAYMENT_TERMS_HISTORY_S.NEXTVAL
2865: ,SYSDATE
2866: ,FND_GLOBAL.USER_ID
2867: ,SYSDATE
2868: ,FND_GLOBAL.USER_ID
2869: ,FND_GLOBAL.LOGIN_ID
2870: ,l_new_term_id
2871: ,l_dist_change_id
2872: ,l_prev_term_hist_id

Line 2869: ,FND_GLOBAL.LOGIN_ID

2865: ,SYSDATE
2866: ,FND_GLOBAL.USER_ID
2867: ,SYSDATE
2868: ,FND_GLOBAL.USER_ID
2869: ,FND_GLOBAL.LOGIN_ID
2870: ,l_new_term_id
2871: ,l_dist_change_id
2872: ,l_prev_term_hist_id
2873: ,l_adj_type_code

Line 2997: l_last_updated_by := FND_GLOBAL.USER_ID;

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

Line 3000: l_last_update_login := FND_GLOBAL.LOGIN_ID;

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

Line 3017: l_last_updated_by := FND_GLOBAL.USER_ID;

3013: l_end_dt := term_rec.end_date;
3014: l_adj_type_code := NULL;
3015: l_term_comments := NULL;
3016: l_last_update_date := SYSDATE;
3017: l_last_updated_by := FND_GLOBAL.USER_ID;
3018: l_creation_date := SYSDATE;
3019: l_created_by := FND_GLOBAL.USER_ID;
3020: l_last_update_login := FND_GLOBAL.LOGIN_ID;
3021: l_changed_flag := 'N';

Line 3019: l_created_by := FND_GLOBAL.USER_ID;

3015: l_term_comments := NULL;
3016: l_last_update_date := SYSDATE;
3017: l_last_updated_by := FND_GLOBAL.USER_ID;
3018: l_creation_date := SYSDATE;
3019: l_created_by := FND_GLOBAL.USER_ID;
3020: l_last_update_login := FND_GLOBAL.LOGIN_ID;
3021: l_changed_flag := 'N';
3022:
3023: END IF;

Line 3020: l_last_update_login := FND_GLOBAL.LOGIN_ID;

3016: l_last_update_date := SYSDATE;
3017: l_last_updated_by := FND_GLOBAL.USER_ID;
3018: l_creation_date := SYSDATE;
3019: l_created_by := FND_GLOBAL.USER_ID;
3020: l_last_update_login := FND_GLOBAL.LOGIN_ID;
3021: l_changed_flag := 'N';
3022:
3023: END IF;
3024:

Line 3361: ,FND_GLOBAL.USER_ID

3357: ,ATTRIBUTE15)
3358: VALUES
3359: (pn_distributions_history_s.NEXTVAL
3360: ,SYSDATE
3361: ,FND_GLOBAL.USER_ID
3362: ,SYSDATE
3363: ,FND_GLOBAL.USER_ID
3364: ,FND_GLOBAL.LOGIN_ID
3365: ,l_dist_change_id

Line 3363: ,FND_GLOBAL.USER_ID

3359: (pn_distributions_history_s.NEXTVAL
3360: ,SYSDATE
3361: ,FND_GLOBAL.USER_ID
3362: ,SYSDATE
3363: ,FND_GLOBAL.USER_ID
3364: ,FND_GLOBAL.LOGIN_ID
3365: ,l_dist_change_id
3366: ,l_dist_id
3367: ,p_hist_dist_tab(j).ACCOUNT_ID

Line 3364: ,FND_GLOBAL.LOGIN_ID

3360: ,SYSDATE
3361: ,FND_GLOBAL.USER_ID
3362: ,SYSDATE
3363: ,FND_GLOBAL.USER_ID
3364: ,FND_GLOBAL.LOGIN_ID
3365: ,l_dist_change_id
3366: ,l_dist_id
3367: ,p_hist_dist_tab(j).ACCOUNT_ID
3368: ,p_hist_dist_tab(j).ACCOUNT_CLASS

Line 3509: ,FND_GLOBAL.USER_ID

3505: ,TERM_COMMENTS)
3506: VALUES
3507: (PN_PAYMENT_TERMS_HISTORY_S.NEXTVAL
3508: ,SYSDATE
3509: ,FND_GLOBAL.USER_ID
3510: ,SYSDATE
3511: ,FND_GLOBAL.USER_ID
3512: ,FND_GLOBAL.LOGIN_ID
3513: ,l_term_id

Line 3511: ,FND_GLOBAL.USER_ID

3507: (PN_PAYMENT_TERMS_HISTORY_S.NEXTVAL
3508: ,SYSDATE
3509: ,FND_GLOBAL.USER_ID
3510: ,SYSDATE
3511: ,FND_GLOBAL.USER_ID
3512: ,FND_GLOBAL.LOGIN_ID
3513: ,l_term_id
3514: ,l_dist_change_id
3515: ,l_prev_term_hist_id

Line 3512: ,FND_GLOBAL.LOGIN_ID

3508: ,SYSDATE
3509: ,FND_GLOBAL.USER_ID
3510: ,SYSDATE
3511: ,FND_GLOBAL.USER_ID
3512: ,FND_GLOBAL.LOGIN_ID
3513: ,l_term_id
3514: ,l_dist_change_id
3515: ,l_prev_term_hist_id
3516: ,l_adj_type_code