eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.RLM_SHIP_DELIVERY_PATTERN_SV dependencies on RLM_SHIP_DELIVERY_PATTERN_SV

Line 1: PACKAGE BODY RLM_SHIP_DELIVERY_PATTERN_SV as

1: PACKAGE BODY RLM_SHIP_DELIVERY_PATTERN_SV as
2: /* $Header: RLMDPSDB.pls 120.2 2005/07/17 18:31:28 rlanka ship $*/
3:
4: --
5: l_DEBUG NUMBER := NVL(fnd_profile.value('RLM_DEBUG_MODE'),-1);

Line 14: PROCEDURE calc_scheduled_ship_date(x_Input IN rlm_ship_delivery_pattern_sv.t_InputRec,

10: PROCEDURE NAME: calc_scheduled_ship_date
11:
12: ==============================================================================*/
13:
14: PROCEDURE calc_scheduled_ship_date(x_Input IN rlm_ship_delivery_pattern_sv.t_InputRec,
15: x_QuantityDate OUT NOCOPY rlm_ship_delivery_pattern_sv.t_OutputTable,
16: x_ReturnMessage OUT NOCOPY rlm_ship_delivery_pattern_sv.t_ErrorMsgTable,
17: x_ReturnStatus OUT NOCOPY NUMBER)
18: IS

Line 15: x_QuantityDate OUT NOCOPY rlm_ship_delivery_pattern_sv.t_OutputTable,

11:
12: ==============================================================================*/
13:
14: PROCEDURE calc_scheduled_ship_date(x_Input IN rlm_ship_delivery_pattern_sv.t_InputRec,
15: x_QuantityDate OUT NOCOPY rlm_ship_delivery_pattern_sv.t_OutputTable,
16: x_ReturnMessage OUT NOCOPY rlm_ship_delivery_pattern_sv.t_ErrorMsgTable,
17: x_ReturnStatus OUT NOCOPY NUMBER)
18: IS
19: --

Line 16: x_ReturnMessage OUT NOCOPY rlm_ship_delivery_pattern_sv.t_ErrorMsgTable,

12: ==============================================================================*/
13:
14: PROCEDURE calc_scheduled_ship_date(x_Input IN rlm_ship_delivery_pattern_sv.t_InputRec,
15: x_QuantityDate OUT NOCOPY rlm_ship_delivery_pattern_sv.t_OutputTable,
16: x_ReturnMessage OUT NOCOPY rlm_ship_delivery_pattern_sv.t_ErrorMsgTable,
17: x_ReturnStatus OUT NOCOPY NUMBER)
18: IS
19: --
20: v_Progress VARCHAR2(3) := '010';

Line 783: rlm_message_sv.sql_error('rlm_ship_delivery_pattern_sv.calc_scheduled_ship_date', v_Progress);

779: END IF;
780: --
781: WHEN OTHERS THEN
782: --
783: rlm_message_sv.sql_error('rlm_ship_delivery_pattern_sv.calc_scheduled_ship_date', v_Progress);
784: --
785: IF (l_debug <> -1) THEN
786: rlm_core_sv.dpop(g_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
787: END IF;

Line 1003: rlm_message_sv.sql_error('rlm_ship_delivery_pattern_sv.determine_sdp_code'

999: --
1000: WHEN OTHERS THEN
1001: --
1002: x_ReturnStatus := g_ERROR;
1003: rlm_message_sv.sql_error('rlm_ship_delivery_pattern_sv.determine_sdp_code'
1004: ,v_Progress);
1005: IF (l_debug <> -1) THEN
1006: rlm_core_sv.dpop(g_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
1007: END IF;

Line 1122: rlm_message_sv.sql_error('rlm_ship_delivery_pattern_sv.find_daily_percent', v_Progress);

1118: EXCEPTION
1119: --
1120: WHEN NO_DATA_FOUND THEN
1121: --
1122: rlm_message_sv.sql_error('rlm_ship_delivery_pattern_sv.find_daily_percent', v_Progress);
1123: --
1124: IF (l_debug <> -1) THEN
1125: rlm_core_sv.dlog(g_DEBUG,'EXCEPTION: When no data found sql error');
1126: rlm_core_sv.dpop(g_SDEBUG);

Line 1133: rlm_message_sv.sql_error('rlm_ship_delivery_pattern_sv.find_daily_percent', v_Progress);

1129: raise;
1130: --
1131: WHEN OTHERS THEN
1132: --
1133: rlm_message_sv.sql_error('rlm_ship_delivery_pattern_sv.find_daily_percent', v_Progress);
1134: --
1135: IF (l_debug <> -1) THEN
1136: rlm_core_sv.dpop(g_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
1137: END IF;

Line 1264: x_Input IN RLM_SHIP_DELIVERY_PATTERN_SV.t_InputRec,

1260:
1261: ==============================================================================*/
1262:
1263: PROCEDURE break_bucket(
1264: x_Input IN RLM_SHIP_DELIVERY_PATTERN_SV.t_InputRec,
1265: x_ReturnMessage IN OUT NOCOPY RLM_SHIP_DELIVERY_PATTERN_SV.t_ErrorMsgTable,
1266: x_WeeklyBucket OUT NOCOPY RLM_SHIP_DELIVERY_PATTERN_SV.t_BucketTable,
1267: x_ReturnStatus OUT NOCOPY NUMBER)
1268: IS

Line 1265: x_ReturnMessage IN OUT NOCOPY RLM_SHIP_DELIVERY_PATTERN_SV.t_ErrorMsgTable,

1261: ==============================================================================*/
1262:
1263: PROCEDURE break_bucket(
1264: x_Input IN RLM_SHIP_DELIVERY_PATTERN_SV.t_InputRec,
1265: x_ReturnMessage IN OUT NOCOPY RLM_SHIP_DELIVERY_PATTERN_SV.t_ErrorMsgTable,
1266: x_WeeklyBucket OUT NOCOPY RLM_SHIP_DELIVERY_PATTERN_SV.t_BucketTable,
1267: x_ReturnStatus OUT NOCOPY NUMBER)
1268: IS
1269: v_Progress VARCHAR2(3) :='010';

Line 1266: x_WeeklyBucket OUT NOCOPY RLM_SHIP_DELIVERY_PATTERN_SV.t_BucketTable,

1262:
1263: PROCEDURE break_bucket(
1264: x_Input IN RLM_SHIP_DELIVERY_PATTERN_SV.t_InputRec,
1265: x_ReturnMessage IN OUT NOCOPY RLM_SHIP_DELIVERY_PATTERN_SV.t_ErrorMsgTable,
1266: x_WeeklyBucket OUT NOCOPY RLM_SHIP_DELIVERY_PATTERN_SV.t_BucketTable,
1267: x_ReturnStatus OUT NOCOPY NUMBER)
1268: IS
1269: v_Progress VARCHAR2(3) :='010';
1270: v_ReturnMessage VARCHAR2(30) ;

Line 1472: x_Input IN rlm_ship_delivery_pattern_sv.t_InputRec,

1468: ==============================================================================*/
1469:
1470: FUNCTION get_weekly_quantity(x_WholeNumber IN BOOLEAN,
1471: x_Count IN NUMBER,
1472: x_Input IN rlm_ship_delivery_pattern_sv.t_InputRec,
1473: x_DivideBy IN NUMBER)
1474: RETURN NUMBER
1475: IS
1476: --

Line 1549: x_Input IN RLM_SHIP_DELIVERY_PATTERN_SV.t_InputRec,

1545:
1546: ==============================================================================*/
1547:
1548: PROCEDURE apply_sdp_to_weekly_bucket(
1549: x_Input IN RLM_SHIP_DELIVERY_PATTERN_SV.t_InputRec,
1550: x_ItemDetailSubtype IN VARCHAR2,
1551: x_DailyPercent IN rlm_core_sv.t_NumberTable,
1552: x_StartDateTime IN DATE,
1553: x_PrimaryQuantity IN NUMBER,

Line 1555: x_QuantityDate IN OUT NOCOPY RLM_SHIP_DELIVERY_PATTERN_SV.t_OutputTable)

1551: x_DailyPercent IN rlm_core_sv.t_NumberTable,
1552: x_StartDateTime IN DATE,
1553: x_PrimaryQuantity IN NUMBER,
1554: x_WholeNumber IN BOOLEAN,
1555: x_QuantityDate IN OUT NOCOPY RLM_SHIP_DELIVERY_PATTERN_SV.t_OutputTable)
1556: IS
1557: v_Progress VARCHAR2(3) :='010';
1558: v_Count NUMBER;
1559: v_MondayDate DATE;

Line 1677: rlm_message_sv.sql_error('rlm_ship_delivery_pattern_sv.apply_sdp_to_weekly_bucket', v_Progress);

1673: EXCEPTION
1674: --
1675: WHEN OTHERS THEN
1676: --
1677: rlm_message_sv.sql_error('rlm_ship_delivery_pattern_sv.apply_sdp_to_weekly_bucket', v_Progress);
1678: --
1679: IF (l_debug <> -1) THEN
1680: rlm_core_sv.dpop(g_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
1681: END IF;

Line 1695: x_input IN rlm_ship_delivery_pattern_sv.t_InputRec,

1691:
1692: ==============================================================================*/
1693:
1694: PROCEDURE apply_sdp_to_daily_bucket(
1695: x_input IN rlm_ship_delivery_pattern_sv.t_InputRec,
1696: x_ItemDetailSubtype IN VARCHAR2,
1697: x_DailyPercent IN rlm_core_sv.t_NumberTable,
1698: x_StartDateTime IN DATE,
1699: x_PrimaryQuantity IN NUMBER,

Line 1700: x_QuantityDate IN OUT NOCOPY rlm_ship_delivery_pattern_sv.t_OutputTable)

1696: x_ItemDetailSubtype IN VARCHAR2,
1697: x_DailyPercent IN rlm_core_sv.t_NumberTable,
1698: x_StartDateTime IN DATE,
1699: x_PrimaryQuantity IN NUMBER,
1700: x_QuantityDate IN OUT NOCOPY rlm_ship_delivery_pattern_sv.t_OutputTable)
1701: IS
1702: v_Progress VARCHAR2(3) :='010';
1703: x_message VARCHAR2(4000);
1704:

Line 1756: x_Input IN rlm_ship_delivery_pattern_sv.t_InputRec,

1752:
1753: ==============================================================================*/
1754:
1755: FUNCTION check_start_date(
1756: x_Input IN rlm_ship_delivery_pattern_sv.t_InputRec,
1757: x_BucketType IN VARCHAR2)
1758: RETURN BOOLEAN
1759: IS
1760: v_Progress VARCHAR2(3) :='010';

Line 1833: FUNCTION find_monday_date(x_Input IN rlm_ship_delivery_pattern_sv.t_InputRec,

1829: FUNCTION NAME: find_monday_date
1830:
1831: ==============================================================================*/
1832:
1833: FUNCTION find_monday_date(x_Input IN rlm_ship_delivery_pattern_sv.t_InputRec,
1834: x_Date IN DATE)
1835: RETURN DATE
1836: IS
1837: v_MondayDate DATE;

Line 1878: x_Input IN rlm_ship_delivery_pattern_sv.t_InputRec,

1874:
1875: ==============================================================================*/
1876:
1877: FUNCTION valid_sdp_date(
1878: x_Input IN rlm_ship_delivery_pattern_sv.t_InputRec,
1879: x_DailyPercent IN rlm_core_sv.t_NumberTable)
1880: RETURN BOOLEAN
1881: IS
1882: v_Valid BOOLEAN := FALSE;

Line 1930: x_Input IN rlm_ship_delivery_pattern_sv.t_InputRec,

1926:
1927: ==============================================================================*/
1928:
1929: FUNCTION previous_valid_sdp_date(
1930: x_Input IN rlm_ship_delivery_pattern_sv.t_InputRec,
1931: x_Date IN DATE,
1932: x_DailyPercent IN rlm_core_sv.t_NumberTable)
1933: RETURN DATE
1934: IS

Line 2076: FUNCTION check_receive_date(x_Input IN rlm_ship_delivery_pattern_sv.t_InputRec,

2072: FUNCTION NAME: check_receive_date
2073:
2074: ==============================================================================*/
2075:
2076: FUNCTION check_receive_date(x_Input IN rlm_ship_delivery_pattern_sv.t_InputRec,
2077: x_ReceiveDate IN DATE)
2078: RETURN BOOLEAN
2079: IS
2080: --

Line 2133: PROCEDURE determine_receive_date(x_Input IN RLM_SHIP_DELIVERY_PATTERN_SV.t_InputRec,

2129: PROCEDURE NAME: determine_receive_date
2130:
2131: ==============================================================================*/
2132:
2133: PROCEDURE determine_receive_date(x_Input IN RLM_SHIP_DELIVERY_PATTERN_SV.t_InputRec,
2134: x_DailyPercent IN rlm_core_sv.t_NumberTable,
2135: x_ReceiveDate IN OUT NOCOPY DATE)
2136: IS
2137:

Line 2206: FUNCTION check_send_date (x_Input IN RLM_SHIP_DELIVERY_PATTERN_SV.t_InputRec,

2202: FUNCTION NAME: check_send_date
2203:
2204: ==============================================================================*/
2205:
2206: FUNCTION check_send_date (x_Input IN RLM_SHIP_DELIVERY_PATTERN_SV.t_InputRec,
2207: x_ShipmentDate IN DATE)
2208: RETURN BOOLEAN
2209: IS
2210: --

Line 2259: x_Input IN rlm_ship_delivery_pattern_sv.t_InputRec,

2255:
2256: ==============================================================================*/
2257:
2258: PROCEDURE determine_send_date(
2259: x_Input IN rlm_ship_delivery_pattern_sv.t_InputRec,
2260: x_DailyPercent IN rlm_core_sv.t_NumberTable,
2261: x_ShipmentDate IN OUT NOCOPY DATE)
2262: IS
2263:

Line 2335: x_Input IN rlm_ship_delivery_pattern_sv.t_InputRec,

2331: FUNCTION NAME: GetTPContext
2332:
2333: ===========================================================================*/
2334: PROCEDURE GetTPContext(
2335: x_Input IN rlm_ship_delivery_pattern_sv.t_InputRec,
2336: x_customer_number OUT NOCOPY VARCHAR2,
2337: x_ship_to_ece_locn_code OUT NOCOPY VARCHAR2,
2338: x_bill_to_ece_locn_code OUT NOCOPY VARCHAR2,
2339: x_inter_ship_to_ece_locn_code OUT NOCOPY VARCHAR2,

Line 2489: rlm_message_sv.sql_error('rlm_ship_delivery_pattern_sv.GetTPContext',v_Progress);

2485: END IF;
2486: --
2487: WHEN OTHERS THEN
2488: --
2489: rlm_message_sv.sql_error('rlm_ship_delivery_pattern_sv.GetTPContext',v_Progress);
2490: --
2491: IF (l_debug <> -1) THEN
2492: rlm_core_sv.dpop(g_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
2493: END IF;

Line 2499: END rlm_ship_delivery_pattern_sv;

2495: raise;
2496:
2497: END GetTPContext;
2498:
2499: END rlm_ship_delivery_pattern_sv;