APPS.FTE_LTL_LOADER dependencies on FTE_TARIFF_CARRIERS

Line 72: fte_tariff_carriers

68: carrier_id,
69: TO_CHAR(new_effective_date, G_DATE_FORMAT),
70: TO_CHAR(new_expiry_date,G_DATE_FORMAT)
71: FROM
72: fte_tariff_carriers
73: WHERE
74: tariff_name = p_tariff_name AND
75: action_code = p_action_code;
76:

Line 91: fte_tariff_carriers tc,

87: dwr.country_code,
88: l.carrier_id
89: FROM
90: fte_lanes l,
91: fte_tariff_carriers tc,
92: wsh_zone_regions ozr,
93: wsh_zone_regions dzr,
94: wsh_regions owr,
95: wsh_regions dwr

Line 1536: -- Cleanup FTE_TARIFF_CARRIERS

1532: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Deleted ' || l_num_lane || ' from FTE_LANES');
1533: END IF;
1534:
1535: --+
1536: -- Cleanup FTE_TARIFF_CARRIERS
1537: --+
1538: DELETE FROM
1539: fte_tariff_carriers
1540: WHERE

Line 1539: fte_tariff_carriers

1535: --+
1536: -- Cleanup FTE_TARIFF_CARRIERS
1537: --+
1538: DELETE FROM
1539: fte_tariff_carriers
1540: WHERE
1541: tariff_name = p_tariff_name AND
1542: action_code = 'N';
1543:

Line 1545: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Deleted ' || SQL%ROWCOUNT || ' rows from fte_tariff_carriers for tariff ' || p_tariff_name);

1541: tariff_name = p_tariff_name AND
1542: action_code = 'N';
1543:
1544: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
1545: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Deleted ' || SQL%ROWCOUNT || ' rows from fte_tariff_carriers for tariff ' || p_tariff_name);
1546: END IF;
1547:
1548: UPDATE
1549: fte_tariff_carriers

Line 1549: fte_tariff_carriers

1545: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Deleted ' || SQL%ROWCOUNT || ' rows from fte_tariff_carriers for tariff ' || p_tariff_name);
1546: END IF;
1547:
1548: UPDATE
1549: fte_tariff_carriers
1550: SET
1551: action_code = 'D',
1552: last_updated_by = G_USER_ID,
1553: last_update_date = SYSDATE,

Line 1560: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Updated ' || sql%rowcount || ' rows in fte_tariff_carriers.');

1556: tariff_name = p_tariff_name AND
1557: action_code = 'M';
1558:
1559: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
1560: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Updated ' || sql%rowcount || ' rows in fte_tariff_carriers.');
1561: END IF;
1562:
1563: FTE_UTIL_PKG.Exit_Debug(l_module_name);
1564: EXCEPTION

Line 4028: -- Update the dates in fte_tariff_carriers

4024: x_status => l_status,
4025: x_error_msg => l_error_msg);
4026:
4027: --+
4028: -- Update the dates in fte_tariff_carriers
4029: --+
4030:
4031: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
4032: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Update FTE_TARIFF_CARRIERS to complete process');

Line 4032: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Update FTE_TARIFF_CARRIERS to complete process');

4028: -- Update the dates in fte_tariff_carriers
4029: --+
4030:
4031: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
4032: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Update FTE_TARIFF_CARRIERS to complete process');
4033: END IF;
4034:
4035: FORALL n IN 1..p_carrier_ids.COUNT
4036: UPDATE

Line 4037: fte_tariff_carriers

4033: END IF;
4034:
4035: FORALL n IN 1..p_carrier_ids.COUNT
4036: UPDATE
4037: fte_tariff_carriers
4038: SET
4039: effective_date = to_date(p_effective_dates(n), G_DATE_FORMAT),
4040: expiry_date = to_date(p_expiry_dates(n), G_DATE_FORMAT),
4041: action_code = 'D',

Line 4859: -- Update the dates in fte_tariff_carriers

4855: END LOOP;
4856: CLOSE GET_TARIFF_LANES;
4857:
4858:
4859: -- Update the dates in fte_tariff_carriers
4860: FORALL p IN 1..l_add_carriers.COUNT
4861: UPDATE
4862: fte_tariff_carriers
4863: SET

Line 4862: fte_tariff_carriers

4858:
4859: -- Update the dates in fte_tariff_carriers
4860: FORALL p IN 1..l_add_carriers.COUNT
4861: UPDATE
4862: fte_tariff_carriers
4863: SET
4864: effective_date = l_add_start_dates(p),
4865: expiry_date = l_add_end_dates(p),
4866: action_code = 'D',

Line 4980: -- Update the dates in fte_tariff_carriers

4976: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Update Tariff Carriers Table');
4977: END IF;
4978:
4979: --+
4980: -- Update the dates in fte_tariff_carriers
4981: --+
4982: FORALL n IN 1..l_modified_carriers.COUNT
4983: UPDATE
4984: fte_tariff_carriers

Line 4984: fte_tariff_carriers

4980: -- Update the dates in fte_tariff_carriers
4981: --+
4982: FORALL n IN 1..l_modified_carriers.COUNT
4983: UPDATE
4984: fte_tariff_carriers
4985: SET
4986: effective_date = l_mod_start_dates(n),
4987: expiry_date = l_mod_end_dates(n),
4988: action_code = 'D',

Line 5331: fte_tariff_carriers

5327: END IF;
5328: END IF;
5329:
5330: UPDATE
5331: fte_tariff_carriers
5332: SET
5333: new_expiry_date = to_date(to_char(to_date(to_char(new_expiry_date, G_DATE), G_DATE_FORMAT)+1-1/24/60/60, G_DATE_FORMAT), G_DATE_FORMAT),
5334: last_updated_by = G_USER_ID,
5335: last_update_date = SYSDATE,