DBA Data[Home] [Help]

APPS.PN_RETRO_ADJUSTMENT_PKG dependencies on FND_GLOBAL

Line 1182: x_created_by => fnd_global.user_id,

1178: x_attribute13 => null,
1179: x_attribute14 => null,
1180: x_attribute15 => null,
1181: x_creation_date => SYSDATE,
1182: x_created_by => fnd_global.user_id,
1183: x_last_update_date => SYSDATE,
1184: x_last_updated_by => fnd_global.user_id,
1185: x_last_update_login => fnd_global.login_id,
1186: x_org_id => l_org_id

Line 1184: x_last_updated_by => fnd_global.user_id,

1180: x_attribute15 => null,
1181: x_creation_date => SYSDATE,
1182: x_created_by => fnd_global.user_id,
1183: x_last_update_date => SYSDATE,
1184: x_last_updated_by => fnd_global.user_id,
1185: x_last_update_login => fnd_global.login_id,
1186: x_org_id => l_org_id
1187: );
1188:

Line 1185: x_last_update_login => fnd_global.login_id,

1181: x_creation_date => SYSDATE,
1182: x_created_by => fnd_global.user_id,
1183: x_last_update_date => SYSDATE,
1184: x_last_updated_by => fnd_global.user_id,
1185: x_last_update_login => fnd_global.login_id,
1186: x_org_id => l_org_id
1187: );
1188:
1189: END IF;

Line 1286: last_updated_by = fnd_global.user_id,

1282: FORALL i IN 0 .. l_payment_id_tbl.COUNT - 1
1283: UPDATE pn_adjustment_details
1284: SET payment_item_id = null,
1285: last_update_date = SYSDATE,
1286: last_updated_by = fnd_global.user_id,
1287: last_update_login = fnd_global.login_id
1288: WHERE payment_item_id = l_payment_id_tbl(i);
1289:
1290: pnp_debug_pkg.log(l_desc ||' (-)');

Line 1287: last_update_login = fnd_global.login_id

1283: UPDATE pn_adjustment_details
1284: SET payment_item_id = null,
1285: last_update_date = SYSDATE,
1286: last_updated_by = fnd_global.user_id,
1287: last_update_login = fnd_global.login_id
1288: WHERE payment_item_id = l_payment_id_tbl(i);
1289:
1290: pnp_debug_pkg.log(l_desc ||' (-)');
1291:

Line 1395: last_updated_by = fnd_global.user_id,

1391: UPDATE pn_payment_items_all
1392: SET actual_amount = ROUND(l_act_amt_tbl(i), l_precision),
1393: estimated_amount = ROUND(l_est_amt_tbl(i), l_precision),
1394: last_update_date = SYSDATE,
1395: last_updated_by = fnd_global.user_id,
1396: last_update_login = fnd_global.login_id
1397: WHERE payment_item_id = l_payment_id_tbl(i);
1398:
1399: l_info := ' deleting items ';

Line 1396: last_update_login = fnd_global.login_id

1392: SET actual_amount = ROUND(l_act_amt_tbl(i), l_precision),
1393: estimated_amount = ROUND(l_est_amt_tbl(i), l_precision),
1394: last_update_date = SYSDATE,
1395: last_updated_by = fnd_global.user_id,
1396: last_update_login = fnd_global.login_id
1397: WHERE payment_item_id = l_payment_id_tbl(i);
1398:
1399: l_info := ' deleting items ';
1400: pnp_debug_pkg.log(l_info);

Line 1499: fnd_global.user_id,

1495: VALUES
1496: (
1497: pn_payment_items_s.nextval,
1498: SYSDATE,
1499: fnd_global.user_id,
1500: SYSDATE,
1501: fnd_global.user_id,
1502: fnd_global.login_id,
1503: ROUND(l_act_amt_tbl(i), l_precision),

Line 1501: fnd_global.user_id,

1497: pn_payment_items_s.nextval,
1498: SYSDATE,
1499: fnd_global.user_id,
1500: SYSDATE,
1501: fnd_global.user_id,
1502: fnd_global.login_id,
1503: ROUND(l_act_amt_tbl(i), l_precision),
1504: ROUND(l_est_amt_tbl(i), l_precision),
1505: l_trx_date_tbl(i),

Line 1502: fnd_global.login_id,

1498: SYSDATE,
1499: fnd_global.user_id,
1500: SYSDATE,
1501: fnd_global.user_id,
1502: fnd_global.login_id,
1503: ROUND(l_act_amt_tbl(i), l_precision),
1504: ROUND(l_est_amt_tbl(i), l_precision),
1505: l_trx_date_tbl(i),
1506: l_start_date_tbl(i),

Line 1673: fnd_global.user_id,

1669: p_adj_table(i).schedule_date,
1670: p_term_id,
1671: p_adj_table(i).amount,
1672: SYSDATE,
1673: fnd_global.user_id,
1674: SYSDATE,
1675: fnd_global.user_id,
1676: fnd_global.login_id
1677: ) RETURNING adjustment_summary_id INTO l_adj_summ_id;

Line 1675: fnd_global.user_id,

1671: p_adj_table(i).amount,
1672: SYSDATE,
1673: fnd_global.user_id,
1674: SYSDATE,
1675: fnd_global.user_id,
1676: fnd_global.login_id
1677: ) RETURNING adjustment_summary_id INTO l_adj_summ_id;
1678:
1679: ELSE

Line 1676: fnd_global.login_id

1672: SYSDATE,
1673: fnd_global.user_id,
1674: SYSDATE,
1675: fnd_global.user_id,
1676: fnd_global.login_id
1677: ) RETURNING adjustment_summary_id INTO l_adj_summ_id;
1678:
1679: ELSE
1680:

Line 1741: fnd_global.user_id,

1737: l_end_date,
1738: p_adj_table(i).amount,
1739: l_group_num,
1740: SYSDATE,
1741: fnd_global.user_id,
1742: SYSDATE,
1743: fnd_global.user_id,
1744: fnd_global.login_id
1745: );

Line 1743: fnd_global.user_id,

1739: l_group_num,
1740: SYSDATE,
1741: fnd_global.user_id,
1742: SYSDATE,
1743: fnd_global.user_id,
1744: fnd_global.login_id
1745: );
1746:
1747: IF p_adj_table(i).adj_summ_id IS NOT NULL THEN

Line 1744: fnd_global.login_id

1740: SYSDATE,
1741: fnd_global.user_id,
1742: SYSDATE,
1743: fnd_global.user_id,
1744: fnd_global.login_id
1745: );
1746:
1747: IF p_adj_table(i).adj_summ_id IS NOT NULL THEN
1748:

Line 1756: last_updated_by = fnd_global.user_id,

1752:
1753: UPDATE pn_adjustment_summaries
1754: SET sum_adj_amount = sum_adj_amount + p_adj_table(i).amount,
1755: last_update_date = SYSDATE,
1756: last_updated_by = fnd_global.user_id,
1757: last_update_login = fnd_global.login_id
1758: WHERE adjustment_summary_id = p_adj_table(i).adj_summ_id;
1759:
1760: END IF;

Line 1757: last_update_login = fnd_global.login_id

1753: UPDATE pn_adjustment_summaries
1754: SET sum_adj_amount = sum_adj_amount + p_adj_table(i).amount,
1755: last_update_date = SYSDATE,
1756: last_updated_by = fnd_global.user_id,
1757: last_update_login = fnd_global.login_id
1758: WHERE adjustment_summary_id = p_adj_table(i).adj_summ_id;
1759:
1760: END IF;
1761:

Line 1984: fnd_global.user_id,

1980: ) VALUES
1981: (
1982: pn_payment_items_s.nextval,
1983: SYSDATE,
1984: fnd_global.user_id,
1985: SYSDATE,
1986: fnd_global.user_id,
1987: fnd_global.login_id,
1988: 0,

Line 1986: fnd_global.user_id,

1982: pn_payment_items_s.nextval,
1983: SYSDATE,
1984: fnd_global.user_id,
1985: SYSDATE,
1986: fnd_global.user_id,
1987: fnd_global.login_id,
1988: 0,
1989: null,
1990: l_sched_dt_tbl(i),

Line 1987: fnd_global.login_id,

1983: SYSDATE,
1984: fnd_global.user_id,
1985: SYSDATE,
1986: fnd_global.user_id,
1987: fnd_global.login_id,
1988: 0,
1989: null,
1990: l_sched_dt_tbl(i),
1991: null,

Line 2071: last_update_login = fnd_global.login_id,

2067: UPDATE pn_payment_terms_history
2068: SET adjustment_type_code = p_adj_type_cd,
2069: total_adj_amount = l_amount,
2070: last_update_date = SYSDATE,
2071: last_update_login = fnd_global.login_id,
2072: last_updated_by = fnd_global.user_id
2073: WHERE term_history_id = p_term_hist_id;
2074:
2075: pnp_debug_pkg.log(l_desc ||' (-)');

Line 2072: last_updated_by = fnd_global.user_id

2068: SET adjustment_type_code = p_adj_type_cd,
2069: total_adj_amount = l_amount,
2070: last_update_date = SYSDATE,
2071: last_update_login = fnd_global.login_id,
2072: last_updated_by = fnd_global.user_id
2073: WHERE term_history_id = p_term_hist_id;
2074:
2075: pnp_debug_pkg.log(l_desc ||' (-)');
2076: